Monday 21 May 2012

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

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

No comments:

Post a Comment