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

TNS-01151: Missing listener name, string, in LISTENER.ORA

2 Answers  


IMG-00512: multiple incompatible scaling parameters found

1 Answers  


SQL-02127: Precompiler/SQLLIB version mismatch

1 Answers  


ORA-12601: TNS:information flags check failed

1 Answers  


PLS-00330: invalid use of type name or subtype name

1 Answers  






ORA-24028: cannot create a reciever non-repudiable single consumer queue

1 Answers  


QSM-02120: compatibility mode must be 9.0 or higher

1 Answers  


ORA-30461: 'string.string' cannot be refreshed because it is marked DISABLED

1 Answers  


ORA-08210: Requested I/O error

1 Answers  


ORA-24008: queue table string.string must be dropped first

1 Answers  


ORA-06259: NETNTT: cannot read from remote process

1 Answers  


ORA-12656: Cryptographic checksum mismatch

1 Answers  


Categories