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-02270: no matching unique or primary key for this column-list

5 Answers  


ORA-25301: cannot specify recipient list during enqueue

1 Answers  


ORA-13774: insufficient privileges to select data from the workload repository

1 Answers  


PCC-00107: The CONNECT statement is Oracle implementation dependent

1 Answers  


ORA-01469: PRIOR can only be followed by a column name

1 Answers  






SQL*Loader-00109: Invalid number of logical records to skip

1 Answers  


ORA-03293: Cluster to be truncated is a HASH CLUSTER

1 Answers  


ORA-19902: incarnation key string not found

1 Answers  


ORA-25403: could not reconnect

1 Answers  


ORA-36208: (XSAGOP05N) In AGGMAP workspace object, you can only specify NAOPERATOR string with the PROPORTIONAL or EVEN operators, not string.

1 Answers  


LPX-00215: processing instruction did not end in "?>"

1 Answers  


PLS-01504: Use of AS phase in CREATE TABLE statement is non_ANSI

1 Answers  


Categories