| _system_trig_enabled [message #54820] |
Sat, 07 December 2002 12:40  |
mecalac
Messages: 1
Registered: December 2002
|
Junior Member |
|
|
can anyone please advice me on the impact if I have set _system_trig_enabled to true when running the script initjvm, rmjvm, catproc, catalog, catexp, utlrp.
what are the resolution that I can used to save my database if there is an impact.
|
|
|
|
| Re: _system_trig_enabled [message #54839 is a reply to message #54820] |
Mon, 09 December 2002 12:23  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
I've worked on database where people have forgotten to turn that off during upgrades and the database still seems to be OK. Make sure that all system/sys objectes are valid.
select object_name, objcet_type, status from dba_objects where status=invalid. They recompiling anything which is not valid. I'd consider trying to re-execute the upgrade steps with the parameter correctly set. Metalink would of course give you more accurate advice...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
