t; >
> >
> >
> > "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
> > &l
nal 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
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 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
> > >
> > >
&g
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
> > >
> > >
&g
etalink, open a TAR, etc.
> >
> > Jared
> >
> >
> >
> >
> >
> > "rahul sharma" <[EMAIL PROTECTED]>
> > Sent by: [EMAIL PROTECTED]
> > 07/03/2003 03:40 AM
> > Please respond to ORACLE-L
> >
> >
> >
TECTED]
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
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.
e 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
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
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.
11 matches
Mail list logo