ORA-30360

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

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

Acción: Remove the reference to the REF operator or disable the REWRITE option on the materialized view.