Oracle Error ORA-32302: object materialized views must be object ID based

Oracle Error Message

ORA-32302: object materialized views must be object ID based

Reason for the Error

An attempt was made to create an object materialized view that is not object ID based.

Solution

Create the materialized view using the OF clause but omit any ROWID or PRIMARY KEY clauses.