Has anyone seen this error before? I am using 8.1.7.
SQL> CREATE OR REPLACE TRIGGER logon_trig
2 AFTER logon ON SCHEMA
4 INSERT INTO log_trig_table (user_id, log_date, action)
5 VALUES (user, sysdate, 'Logging on");
AFTER logon ON SCHEMA
ERROR at line 2:
ORA-00406: COMPATIBLE parameter needs to be 220.127.116.11.0 or greater
Thank you in advance!!
did you check the comatible parameter on your DB ( init.ora ) ???
make sure it will have 8.1.7 ..
if you change this parameter , you may need to bounce the DB..
What you are using and what your compatible init.ora parameter setting is may be entirely different. Check what you compatible setting is (view the init.ora file, or you can do "show parameter com"). If you setting is not 18.104.22.168 or higher (as the error mentions), you can't do that statement.
You guys are right, thanks! I had COMPATIBLE = 8.0.5.
Once I bounced the database, it's working!
Click Here to Expand Forum to Full Width