Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SYS can't own triggers?!
They'll probably be others who will ask you:
Why are you trying to create triggers on SYS objects?
Its probably a catch-22 but a person who does not know that
he cannot create triggers on SYS objects is the last person who
should be creating triggers on SYS objects (i.e. if it were possible)
:)) Sorry. Could not help myself.
I don't know the complete answer but I can imagine a scenario when a before insert trigger is created on obj# table which changes the name of the object before inserting. DB will quickly die down. Why somebody would do this .. well ..
There can be so many other scenarios .. you just use your imagination.
Anurag
"Peter Chatterton" <peter_at_chatterton.name> wrote in message
news:WlD69.6257$2T2.1099477_at_news20.bellglobal.com...
> I ran the wrong script by mistake and got an ORA-04089.
> The manual very helpfully says:
>
> ORA-04089 cannot create triggers on objects owned by SYS
> Cause: An attempt was made to create a trigger on an object owned by
> SYS.
> Action: Do not create triggers on objects owned by SYS.
>
> Can someone explain the sense, if any, behind this; hopefully in simple
> terms?
>
> Thanks,
> Peter.
>
>
>
>
Received on Wed Aug 14 2002 - 21:51:49 CDT