Oracle DB Error ORA-12036 updatable materialized view log is not empty, refresh materialized view

The following is the cause of this error:

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 you can take to resolve this issue: 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.

Tags: Database, Microsoft, Oracle, SQL, Software, DBMS, Error Messages, Directory

Related