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 > you need) > > On 2003.07.04 10:54, "Jamadagni, Rajendra" wrote: > > 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 > > > > -----Original Message----- > > Sent: Thursday, July 03, 2003 1:39 PM > > To: Multiple recipients of list ORACLE-L > > !!!! > > > > > > At first glance it appears that you have created a self referencing > > trigger. > > > > You can't drop it, because dropping it fires the trigger. > > > > Check metalink, open a TAR, etc. > > > > Jared > > > > > > > > > > > > "rahul sharma" <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 07/03/2003 03:40 AM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> cc: > > Subject: cannot disable or drop the ON DATABASE trigger > > !!!! > > > > > > Help list... i have created the following in 8.1.5 instance > > > > CREATE OR REPLACE TRIGGER DDL_TRIGGER BEFORE > > CREATE OR ALTER OR DROP ON DATABASE > > > > BEGIN > > null; > > END; > > / > > > > and now i cannot drop or disable this trigger !!!! > > > > ERROR at line 1: > > ORA-04045: errors during recompilation/revalidation of SYS.DDL_TRIGGER > > > > > > i'm loggin into svrmgrl and connecting as internal to try drop or > > disable.. > > is this a bug ?? > > > > TIA > > > > Rahul.. > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: rahul sharma > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > San Diego, California -- Mailing list and web hosting services > > --------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > San Diego, California -- Mailing list and web hosting services > > --------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > > > ********************************************************************This > > e-mail message is confidential, intended only for the named recipient(s) > > above and may contain information that is privileged, attorney work > > product or exempt from disclosure under applicable law. If you have > > received this message in error, or are not the named recipient(s), please > > immediately notify corporate MIS at (860) 766-2000 and delete this e-mail > > message from your computer, Thank you. > > *********************************************************************2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).