QSM-02123: subquery and UNION mv's must be primary key mv's



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

Post New Answer

More Oracle Errors Interview Questions

PLS-00541: size or length specified is too large.

1 Answers  


LSX-00149: duplicated ID specified in "~S"

1 Answers  


ORA-03291: Invalid truncate option - missing STORAGE keyword

1 Answers  


ORA-00076: dump string not found

1 Answers  


NZE-28791: certificate verification failure

1 Answers  






ORA-32301: object-relational materialized views must be primary key based

1 Answers  


PLS-00617: at least one result in the CASE expression must not be NULL

1 Answers  


ORA-08462: raw buffer contains invalid decimal data

1 Answers  


ORA-00033: current session has empty migration password

1 Answers  


RMAN-06496: must use the TO clause when the database is mounted or open

1 Answers  


ORA-02194: event specification syntax error string (minor error string) near 'string'

1 Answers  


ORA-02823: Buffer is not aligned.

1 Answers  


Categories