Quick Search:
 
 Oracle Database Error: ORA-30396      [Return To Oracle Error Index] Jump to:  
Oracle Error: ORA-30396

Error Description:
Rewrite equivalence procedures require the COMPATIBLE parameter to be string or greater

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


There haven't been any comments added for this error yet. You may add one if you like.  Add a comment 
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org