QSM-02058: set operator in mv and compatibility mode is less
than 9.0
- 1 Answers
- 1459 Views
- I also Faced
- E-Mail Answers
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 |
DRG-11875: Access Scheme Is Not Allowed
ORA-14304: List partitioning method expects a single partitioning column
ORA-14100: partition extended table name cannot refer to a remote object
ORA-01946: DEFAULT TABLESPACE already specified
ORA-06125: NETTCP: ORASRV exited unexpectedly
ORA-09952: scgcmn: lk_open_convert unexpected return: open failed
PLS-00429: unsupported feature with RETURNING clause
LPX-00217: invalid character ~1u (~2x)
ORA-01135: file string accessed for DML/query is offline
LSX-00116: mutually exclusive facets are not allowed
AUD-00807: SpeechContains: index of indextype ORDSpeechIndex is required
SQL-02151: Invalid host variable for exact numeric SET statement item
Oracle Errors 
