Oracle Error ORA-23472: materialized view “string”.”string” must be atomically refreshed

Oracle 16 Views 0 Min Read

Oracle Error Message

ORA-23472: materialized view “string”.”string” must be atomically refreshed

Reason for the Error

Non-atomic refresh is not supported for the specified materialized view.

Solution

Set the value of the ATOMIC parameter to FALSE in the refresh procedure being used or remove the specified materialized view from the set of materialized views being refreshed.

Tags: