QSM-02123: subquery and UNION mv's must be primary key mv's
- 1 Answers
- 2110 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: The capability in question is not supported when the
materialized view is not a primary key materialized view and
uses subqueries or the union operator in this context.
Action: Re-create the materialized view as a primary key
materialized view.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-14636: only 2 resulting subpartition can be specified for SPLIT SUBPARTITION
ORA-29914: ODCIGETINTERFACES routine does not return required stream version
O2I-00132: Unable to close a Java file
ORA-31066: Insertion of string into string creates a cycle
ORA-06321: IPA: Cannot reach the remote side
NZE-29191: OID connection information not set
ORA-25302: Operation not possible for non-buffered queue string
ORA-06702: TLI Driver: cannot allocate context area
PLS-00251: RETURN, for actual function return, must be last in the parameters clause
ORA-09272: remote os logon is not allowed
ORA-30939: Order violation: Element 'string' may not follow element 'string'
ORA-06525: Length Mismatch for CHAR or RAW data
Oracle Errors 
