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-23534: missing column in materialized view container table "string"."string"
ORA-29836: failed to validate referenced operators
ORA-25244: dequeue index key not found, QUEUE string, rowid string
ORA-12164: TNS:Sqlnet.fdf file not present
ORA-28200: IDENTIFIED USING already specified
ORA-24387: Invalid attach driver
ORA-31084: error while creating table "string"."string" for element "string"
ORA-39956: duplicate setting for PL/SQL compiler parameter string
ORA-15045: ASM file name 'string' is not in reference form
TNS-00122: Missing ADDRESS(es) in TNSNET.ORA file
ORA-19501: read error on file "string", blockno string (blocksize=string)
RMAN-08056: skipping datafile string because it has not changed