QSM-02058: set operator in mv and compatibility mode is less
than 9.0



QSM-02058: set operator in mv and compatibility mode is less than 9.0..

Answer / guest

Cause: The capability in question is not supported when the
materialized view uses a set operator and the compatibility
mode is less than 9.0.

Action: Re-phrase the query to avoid the use of set
operators or set the compatibility mode to 9.0 or greater.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02764: Invalid package mode

1 Answers  


RMAN-06250: Report of files that need backup due to unrecoverable operations

1 Answers  


NZE-28771: Data source is not yet initialized.

1 Answers  


SQL*Loader-00806: unknown record format specified for data file

1 Answers  


ORA-12427: invalid input value for string parameter

1 Answers  






TNS-00072: * start - start up process_name

1 Answers  


DRG-50805: failed to close cursor

1 Answers  


PROC-00021: Maximum permitted depth of the OCR tree is reached

1 Answers  


ORA-03279: invalid INSTANCE specified

1 Answers  


TNS-01026: Start Date string

1 Answers  


QSM-01037: Query Rewrite failed to allocate the necessary query join graph

1 Answers  


LRM-00119: unable to obtain a valid value for 'string'

1 Answers  


Categories