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

ORA-14519: Conflicting tablespace blocksizes for string string: Tablespace string block size string [string] conflicts with previously specified/implied tablespace string block size string [string]

1 Answers  


ORA-03296: cannot resize datafile - file string not found

1 Answers  


DRG-10705: invalid value string for attribute string

1 Answers  


ORA-00477: SNP* process terminated with error

1 Answers  


ORA-06774: TLI Driver: error sending break mode

1 Answers  






DRG-11111: value of string must be between string and string

1 Answers  


ORA-03279: invalid INSTANCE specified

1 Answers  


TNS-00235: Aborting connection: Protocol Apapter errors: string;number,number string;number,number

1 Answers  


ORA-14637: cannot merge a subpartition with itself

1 Answers  


TNS-00129: Internal error - Failed to create new community

1 Answers  


ORA-31672: Worker process string died unexpectedly.

1 Answers  


ORA-12815: value for INSTANCES must be greater than 0

1 Answers  


Categories