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 |
PLS-00541: size or length specified is too large.
LSX-00149: duplicated ID specified in "~S"
ORA-03291: Invalid truncate option - missing STORAGE keyword
ORA-00076: dump string not found
NZE-28791: certificate verification failure
ORA-32301: object-relational materialized views must be primary key based
PLS-00617: at least one result in the CASE expression must not be NULL
ORA-08462: raw buffer contains invalid decimal data
ORA-00033: current session has empty migration password
RMAN-06496: must use the TO clause when the database is mounted or open
ORA-02194: event specification syntax error string (minor error string) near 'string'
ORA-02823: Buffer is not aligned.