Database Error Messages

ORA-12036

updatable materialized view log is not empty, refresh materialized view

Cause

The updatable materialized view log was not empty. The updatable materialized view log must be empty before an updatable rowid materialized view can be altered to a primary key materialized view.


Action

Ensure that updatable materialized view log is empty by refreshing the materialized view before converting the updatable ROWID materialized view to a primary key materialized view.