Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re[2]: (solved?) cannot disable or drop the ON DATABASE trigger !

Re[2]: (solved?) cannot disable or drop the ON DATABASE trigger !

From: Robert Eskridge <bryny_at_dfweahs.net>
Date: Sun, 06 Jul 2003 13:48:49 -0700
Message-ID: <F001.005C3936.20030706131924@fatcity.com> 





One finger per big mistake is a pretty good policy.  Not only does it
slow down their rate but it pretty well limits them to ten.





RC> and did you explain to this junior that if he ever does it again, he
RC> will  be minus a few fingers?


RC> Even if "things are okay now" and you could do a shutdown/startup and
RC> took a backup, I'd export the database and recreate it. The backup you
RC> took is of the system AFTER the deletion from trigger$.  He's
RC> invalidated your support contract by doing that.






RC> --- rahul <[EMAIL PROTECTED]> wrote:


>> 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).

>> > > >

>> > > >

>> > > > 



>>

RC> ********************************************************************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.

>> > > >



>>

RC> *********************************************************************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).

>> > 

>> 



RC> === message truncated ===



RC> __________________________________
RC> Do you Yahoo!?
RC> SBC Yahoo! DSL - Now only $29.95 per month!
RC> http://sbc.yahoo.com




RC> -- 


RC> Please see the official ORACLE-L FAQ: http://www.orafaq.net





-rje


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Robert Eskridge
  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 - 15:48:49 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US