You are here: Home // Oracle 11g // 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. See the solution below.

Error solution: Include all of the master's primary key columns in the materialized view query or create a ROWID materialized view.

Database version: Oracle 11g Release 2 (11.2)

Tags: ,

Leave a Reply

Copyright © 2009 Oracle Error Codes Database. All rights reserved.
Powered by WordPress.
Promotes: zakłady bukmacherskie KRS plomby samoprzylepne Bydgoszcz sportowy sklep pens4all