ORA-12016: materialized view does not include all primary
key columns



ORA-12016: materialized view does not include all primary key columns..

Answer / guest

Cause: The query that instantiates the materialized view did
not include all of the columns in the master's primary key
constraint.

Action: Include all of the master's primary key columns in
the materialized view query or create a ROWID 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

LSX-00253: branch is empty

1 Answers  


IMP-00056: multiple devices specified for tape input

1 Answers  


ORA-23380: propagation mode "string" is not valid

1 Answers  


ORA-25010: Invalid nested table column name in nested table clause

1 Answers  


ORA-02094: replication option not installed

1 Answers  


ORA-39600: Queue keys needs to be a suffix of cluster key.

1 Answers  


ORA-33036: (XSAGDNGL17) ARGS option workspace object must be a TEXT variable.

1 Answers  


ORA-02834: Server unable to open file

1 Answers  


ORA-25257: consumer must be specified with a multi-consumer queue

1 Answers  


ORA-13436: GeoRaster metadata dimensionSize error

1 Answers  


ORA-12653: Authentication control function failed

1 Answers  


ORA-02339: invalid column specification

1 Answers  


Categories