Oracle Error Codes

All Oracle Database Error Codes

Oracle database error code ORA-23415 – materialized view log for “string”.”string” does not record the primary key

Oracle Database Error Code ORA-23415 Description :

materialized view log for “string”.”string” does not record the primary key

Error Cause:

A primary key materialized view is being fast refreshed, but the materialized view log does not record primary key information.

How to Solve :

Use the CREATE MATERIALIZED VIEW LOG…ADD PRIMARY KEY command to begin recording primary key information in the materialized view log.