Oracle Error Codes

All Oracle Database Error Codes

Oracle database error code ORA-32302 – object materialized views must be object ID based

Oracle Database Error Code ORA-32302 Description :

object materialized views must be object ID based

Error Cause:

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

How to Solve :

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