How to fix the Oracle error ORA-12016: materialized view does not include all primary key columns?

In this post, you’ll learn more about the Oracle ErrorORA-12016: materialized view does not include all primary key columns with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

Reason for the Error ORA-12016: materialized view does not include all primary key columns

The query that instantiates the materialized view did not include all of the columns in the master’s primary key constraint.

How to fix the Error ORA-12016: materialized view does not include all primary key columns ?

You can fix this error in Oracle by following the below steps

Include all of the master’s primary key columns in the materialized view query or create a ROWID materialized view.