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

From: Mladen Gogala <mgogala_at_adelphia.net>
Date: Fri, 04 Jul 2003 10:36:48 -0700
Message-ID: <F001.005C3658.20030704102926@fatcity.com>

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 ??

Call OWS
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

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