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

ORA-01326: compatability of 9.0 or greater required to build into the logstream

1 Answers  


CLSR-00528: RACGONS: host and port number already configured in OCR

1 Answers  


ORA-12990: duplicate option specified

1 Answers  


PLS-00993: Cursor Variables cannot be passed as RPC arguments or results

1 Answers  


ORA-00335: online log string: No log with this number, log does not exist

1 Answers  






KUP-04085: duplicate directory object string and file string specified for unload

1 Answers  


SQL*Loader-00416: SDF clause for field string in table string references a non existent field.

1 Answers  


ORA-13156: table to be registered string.string is not empty

1 Answers  


NNL-01071: Command-line parameter file name: string

1 Answers  


ORA-02038: define is not allowed for array type

1 Answers  


QSM-01123: self-join algorithm could not resolve multiple instances

1 Answers  


ORA-07803: slpdtb: invalid packed decimal nibble

1 Answers  


Categories