Oracle Error ORA-30360: REF not supported with query rewrite

Oracle Error Message

ORA-30360: REF not supported with query rewrite

Reason for the Error

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

Solution

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