ORA-30396: rewrite equivalence procedures require the COMPATIBLE parameter to be string or greater

Cause: Query rewrite equivalence APIs require 10.1 or higher compatibility setting:

o DBMS_ADVANCED_REWRITE.DECLARE_REWRITE_EQUIVALENCE

o DBMS_ADVANCED_REWRITE.ALTER_REWRITE_EQUIVALENCE

o DBMS_ADVANCED_REWRITE.DROP_REWRITE_EQUIVALENCE

o DBMS_ADVANCED_REWRITE.VALIDATE_REWRITE_EQUIVALENCE

Action: Shut down and restart with an appropriate compatibility setting. //

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/