Hi Rahul in your case (8i ) put _system_trig_enabled = FALSE in your init.ora file, bounce the DB and drop the trigger.
Nota : In 9i you can use alter system set "_system_trig_enabled"=false; HTH you wrote: >> 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). >> > Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gilles PARC 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).
