| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> (solved?) cannot disable or drop the ON DATABASE trigger !
ok... now i'm praying... cos after i had sent this mail to the list askling
for suggestions.. my junior DBA deleted the trigger from trigger$ !!!!!
things are "ok now" he says... and this _is_ a production schema.. !
we are _not_ encountring any errors now, but i did shutdown/startup and took a new base backup.... and i will continue to pray for some time to come... ;-((
-rahul
PS: this startup migrate is news to me.. i should have looked some more in the manuals... big thanks..
On Sat, 05 Jul 2003 10:24:24 -0800, Jared Still <[EMAIL PROTECTED]> wrote :
>
> 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
> > "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
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul 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).Received on Sun Jul 06 2003 - 10:21:24 CDT
 |
 |