Oracle database error code ORA-30360 – REF not supported with query rewrite

Oracle Database Error Code ORA-30360 Description :
REF not supported with query rewrite
Error Cause:
The statement contained a REF operator. Repeatable behavior cannot be guaranteed with the REF operator. Therefore, query rewrite cannot support the REF operator.

How to Solve :
Remove the reference to the REF operator or disable the REWRITE option on the materialized view.


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , ,
No Comment Yet   
«
»