Wednesday 15 February 2012

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

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

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.

No comments:

Post a Comment