How to fix the Oracle error ORA-12072: updatable materialized view log data for “string”.”string” cannot be created?

In this post, you’ll learn more about the Oracle ErrorORA-12072: updatable materialized view log data for “string”.”string” cannot be created with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-12072: updatable materialized view log data for “string”.”string” cannot be created

Reason for the Error ORA-12072: updatable materialized view log data for “string”.”string” cannot be created

The updatable materialized view was missing the updatable materialized view log required to track updates made to the materialized view.

How to fix the Error ORA-12072: updatable materialized view log data for “string”.”string” cannot be created ?

You can fix this error in Oracle by following the below steps

Create an updatable materialized view log.