Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 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      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 144 users online    © 2009 psoug.org

PSOUG LOGIN
Username: 
Password: 
Forgot your password?