Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-02123: subquery and UNION mv's must be primary key mv's
- 1 Answers
- 2627 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-22890: cannot specify name for REF column constraint
IMG-00701: unable to set the properties of an empty image
ORA-09828: SCLFR: atomic latch return error.
ORA-12984: cannot drop partitioning column
QSM-02177: MV with UNION ALL in a view must match the view's SELECT list
QSM-00793: the specified SQL Tuning Set string does not exist
ORA-25305: enqueue failed, expiration must be zero for queue string.string
ORA-09212: sfwfbmt: error writing to file
ORA-25189: illegal ALTER TABLE option for an index-organized table
LSX-00123: base type is required
PLS-00211: CASE labels or ranges must not be duplicated in different WHEN clauses
ORA-06003: NETASY: port write failure
Oracle Errors 
