Re: [PMX:##] Re: cannot disable or drop the ON DATABASE trigger !

2003-07-11 Thread Jared Still
It's also in 8i. Jared On Friday 04 July 2003 11:29, Mladen Gogala wrote: Parameter to disable database triggers is: _system_trig_enabled = FALSE This is 9i parameter. Alternatively, if you start the database up in the migrate mode, system triggers will be disable (startup migrate is what

Re: [PMX:##] Re: cannot disable or drop the ON DATABASE trigger !

2003-07-05 Thread Jared Still
D'oh! Shoulda thought of that. It's standard procedures on upgrades. Thanks Mladen. On Friday 04 July 2003 11:29, Mladen Gogala wrote: Parameter to disable database triggers is: _system_trig_enabled = FALSE This is 9i parameter. Alternatively, if you start the database up in the

RE: [PMX:##] Re: cannot disable or drop the ON DATABASE trigger !

2003-07-04 Thread Jamadagni, Rajendra
Title: RE: [PMX:##] Re: cannot disable or drop the ON DATABASE trigger This will teach you that you should be _very_ careful when dealing with sys schema. what's that parameter to disable sys triggers ?? 1. Call OWS 2. If this is production DB, keep your resume ready. Raj

Re: [PMX:##] Re: cannot disable or drop the ON DATABASE trigger !

2003-07-04 Thread Mladen Gogala
Parameter to disable database triggers is: _system_trig_enabled = FALSE This is 9i parameter. Alternatively, if you start the database up in the migrate mode, system triggers will be disable (startup migrate is what you need) On 2003.07.04 10:54, Jamadagni, Rajendra wrote: This will teach