Re: ORA-00406: COMPATIBLE parameters needs to be 18.104.22.168.0 or grater
Originally posted by nmoreno
An application creates dinamically tables, triggers, packages, etc.
It works correctly with Oracle 8.1.6, but It doesn't work with Oracle 8.1.7.
This is the error message:
ORA-00406: COMPATIBLE parameters needs to be 22.214.171.124.0 or grater.
The answer is staring you in the face. There is a database parameter called COMPATIBLE that is used for backwards compatibility. Your 8.1.7 database apparently has this set to a LOWER value than 126.96.36.199.0, e.g. 188.8.131.52.0, which was a version of Oracle that didn't support whatever it is you are trying to do.
The solution is to update the COMPATIBLE parameter to a higher value. This is something the DBA has to do for you.