ORA-30360: REF not supported with query rewrite



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-25207: enqueue failed, queue string.string is disabled from enqueueing

1 Answers  


ORA-30341: dropped level has references

1 Answers  


ORA-14265: data type or length of a table subpartitioning column may not be changed

1 Answers  


PLS-00318: type "string" is malformed because it is a non-REF mutually recursive type

1 Answers  


RMAN-08547: channel string: no autobackups found in the recovery area

1 Answers  






NZE-29160: NZ library being used is different.

1 Answers  


CLSR-06504: Service name not in SERVICE_NAMES

1 Answers  


ORA-23476: cannot import from string to string

1 Answers  


ORA-09745: smscre: vm_allocate error, unable to create shared memory.

1 Answers  


ORA-02281: duplicate or conflicting CACHE/NOCACHE specifications

1 Answers  


ORA-16793: Logical Standby Database Guard is unexpectedly OFF

1 Answers  


ORA-14306: List value 'string' specified twice in partitions 'string', 'string'

1 Answers  


Categories