Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SYS can't own triggers?!

SYS can't own triggers?!

From: Peter Chatterton <peter_at_chatterton.name>
Date: Wed, 14 Aug 2002 21:20:27 -0400
Message-ID: <WlD69.6257$2T2.1099477@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 - 20:20:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US