ora - 00406 COMPATIBLE parameter needs ...

[oraka6]

Has anyone seen this error before? I am using 8.1.7.

SQL> CREATE OR REPLACE TRIGGER logon_trig
2 AFTER logon ON SCHEMA
3 BEGIN
4 INSERT INTO log_trig_table (user_id, log_date, action)
5 VALUES (user, sysdate, 'Logging on");
6 END;
7 /
AFTER logon ON SCHEMA
*
ERROR at line 2:
ORA-00406: COMPATIBLE parameter needs to be 8.1.0.0.0 or greater

Thank you in advance!!

[mrvajrala]

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..

[stecal]

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 8.1.0.0 or higher (as the error mentions), you can't do that statement.

[oraka6]

You guys are right, thanks! I had COMPATIBLE = 8.0.5.
Once I bounced the database, it's working!