Unanswered: COMPATIBLE parameter needs to be 220.127.116.11.0
Using DDL Triggers i want to track all changes to database .
Whatever changes to database new entries to the stats$ddl_log table.
I got the below error when executing the system level triggers(Our database 8i(8.1.6) enterprise edition)
SQL> select value
2 from v$parameter
3 where name ='compatible'
It will obviously show a value LOWER than 18.104.22.168.0.
To use the feature you want to use you need to set the COMPATIBLE parameter to 22.214.171.124.0 or higher (as the error message said!)
This is something you must take up with your DBA.
The reason it currently has a lower value than your database version is probably that it was set that way when the database was originally upgraded, to prevent people from using new features in case the upgrade had to be backed out. That must have been a long time ago now, so it shouldn't be an issue to set it to 126.96.36.199.0