Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

RMAN-06432: recovery catalog dropped

1 Answers  


ORA-16744: The DG_CONFIG list of LOG_ARCHIVE_CONFIG parameter is full.

1 Answers  


PLS-01409: Use of 'PRIOR_' token

1 Answers  


ORA-02082: a loopback database link must have a connection qualifier

1 Answers  


PLW-05000: mismatch in NOCOPY qualification between specification and body

1 Answers  






DRG-13305: 'off' attribute value must be in the range string..string, at line string

1 Answers  


PLS-01463: STDDEV is not a standard set function

1 Answers  


DRG-11218: malformed mail line, line string

1 Answers  


DRG-52200: invalid state during export

1 Answers  


PROT-00006: The specified import file cannot be found

1 Answers  


ORA-12637: Packet receive failed

1 Answers  


ORA-00226: operation disallowed while alternate controlfile open

1 Answers  






Categories