Oracle Error ORA-32301: object-relational materialized views must be primary key based

Oracle Error Message

ORA-32301: object-relational materialized views must be primary key based

Reason for the Error

An attempt was made to create an object-relational materialized view that is not primary key based.

Solution

Create the materialized view with the PRIMARY KEY keyword.