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 [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 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: [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).
(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 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: [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
(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 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: [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
Re: (solved?) cannot disable or drop the ON DATABASE trigger !
and did you explain to this junior that if he ever does it again, he will be minus a few fingers? Even if things are okay now and you could do a shutdown/startup and took a backup, I'd export the database and recreate it. The backup you took is of the system AFTER the deletion from trigger$. He's invalidated your support contract by doing that. --- 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). 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
Re[2]: (solved?) cannot disable or drop the ON DATABASE trigger !
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
Re: [PMX:##] Re: cannot disable or drop the ON DATABASE trigger !
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 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: [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).
RE: [PMX:##] Re: cannot disable or drop the ON DATABASE trigger !
Title: RE: [PMX:##] Re: cannot disable or drop the ON DATABASE trigger 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- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 03, 2003 1:39 PM To: Multiple recipients of list ORACLE-L Subject: [PMX:##] Re: cannot disable or drop the ON DATABASE trigger 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 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
Re: [PMX:##] Re: cannot disable or drop the ON DATABASE trigger !
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 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 -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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).
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).
Re: cannot disable or drop the ON DATABASE trigger !!!!
Are you sure that you created the trigger on sys schema? with the sys user? I got something similar when, by mistake, I created a logon trigger on another schema... with another username I whould check: select owner, object_name, object_type, status from dba_objects where object_name = 'DDL_TRIGGER' HTH JL --- rahul sharma [EMAIL PROTECTED] 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). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado 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).
Re: cannot disable or drop the ON DATABASE trigger !!!!
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).