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

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" <rahul_at_infotech.co.id>
> > Sent by: ml-errors_at_fatcity.com
> > 07/03/2003 03:40 AM
> > Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L
> > <ORACLE-L_at_fatcity.com> 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: rahul_at_infotech.co.id
> >
> > 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: ListGuru_at_fatcity.com (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: Jared.Still_at_radisys.com
> >
> > 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: ListGuru_at_fatcity.com (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: jkstill_at_cybcon.com

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: ListGuru_at_fatcity.com (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).