QSM-02123: subquery and UNION mv's must be primary key mv's
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-24367: user handle has not been set in service handle
ORA-01243: system tablespace file suffered media failure
ORA-28651: Primary index on IOTs can not be marked unusable
ORA-27195: proxy copy not supported
RMAN-06435: recovery catalog owner is string
IMG-02005: 2FF05 - incorrect color specification
QSM-00512: invalid summaries specified in the retention-list
PCB-00300: Datatype for host variable not supported by ANSI "string"
ORA-00335: online log string: No log with this number, log does not exist
ORA-06430: ssaio: Seals do not match
VID-00702: unable to initialize video processing environment
ORA-25182: feature not currently available for index-organized tables