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

IMG-00902: VIR signature free failed

1 Answers  


ORA-08449: invalid numeric symbol found in picture mask

1 Answers  


ORA-09989: attempt to use invalid skgmsdef struct pointer

1 Answers  


ORA-38307: object not in RECYCLE BIN

1 Answers  


ORA-30037: Cannot perform parallel DML after a prior DML on the object

1 Answers  


IMG-02004: 2FF04 - incorrect feature list specification

1 Answers  


ORA-36906: (XSAGDNGL45) 4. Model only includes one non-step dimension in the equations.

1 Answers  


ORA-32775: cannot change size attributes of read only tablespace string

1 Answers  


RMAN-10006: error running SQL statement: string

1 Answers  


DRG-52104: the Oracle Text environment could not initialize

1 Answers  


PROC-00013: Cannot perform cluster registry operation because one of the parameters is NULL.

1 Answers  


ORA-13029: Invalid SRID in the SDO_GEOMETRY object

1 Answers  


Categories