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