Friday, July 06, 2012

ORA-04089


Looking through some old documentation, I read that you cannot create triggers on tables owned by SYS. I decided to see if this still applies in Oracle 11.2 and it does:

SQL> create trigger andrews_trigger
  2  after insert on sys.impdp_stats
  3  begin
  4  null;
  5  end;
  6  /
create trigger andrews_trigger
               *
ERROR at line 1:
ORA-04089: cannot create triggers on objects owned by SYS

SQL>

No comments: