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-25291: Buffer does not exist for the specified queue

1 Answers  


TNS-01155: Incorrectly specified SID_LIST_string parameter in LISTENER.ORA

1 Answers  


RMAN-05010: target database must be opened in READ WRITE mode for TSPITR

1 Answers  


TNS-04037: Connections refer to string.

1 Answers  


PROC-00031: Storage device for the cluster registry is too small

1 Answers  






ORA-02329: column of datatype string cannot be unique or a primary key

1 Answers  


ORA-06780: TLI Driver: recv error code failed

1 Answers  


ORA-29527: created Java source string"string"

1 Answers  


ORA-06145: NETTCP: unable to start ORASRV: images not installed

1 Answers  


ORA-22634: Error adding new instance to AnyDataSet

1 Answers  


NNO-00261: cannot construct configuration checkpoint file name

1 Answers  


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

1 Answers  


Categories