ORA-30360: REF not supported with query rewrite

Cause: The statement contained a REF operator. Repeatable behavior cannot be guaranteed with the REF operator. Therefore, query rewrite cannot support the REF operator.

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

Error Type: ORA

• Additional information for ORA-30360: REF not supported with query rewrite30360
Discussions and solutions for Oracle Database Error ORA-30360: REF not supported with query rewrite Developer anwers for Oracle Database Error ORA-30360: REF not supported with query rewrite FAQs for ORA-30360: REF not supported with query rewrite search others tips for ORA-30360: REF not supported with query rewrite