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-02397: exceeded PRIVATE_SGA limit, you are being logged off

1 Answers  


ORA-09364: Windows 3.1 Two-Task driver unable to create hidden window

1 Answers  


ORA-06118: NETTCP: unable to complete handshake with ORASRV

1 Answers  


ORA-40261: input data for model build contains negative values

1 Answers  


ORA-19562: file string is empty

1 Answers  






ORA-39040: Schema expression "string" must identify exactly one schema.

1 Answers  


RMAN-06118: a backup controlfile older than SCN string must be used for this recovery

1 Answers  


ORA-25000: invalid use of bind variable in trigger WHEN clause

1 Answers  


ORA-23456: flavor string does not contain "string"

1 Answers  


IMG-00840: image structure allocation failed

1 Answers  


ORA-31600: invalid input value string for parameter string in function string

1 Answers  


ORA-26715: time limit reached

1 Answers  


Categories