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

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

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.

Share:

Leave a Reply

You May Also Like

Oracle Error Message CLSGN-32767: Internal error. Reason for the Error An unexpected error occurred. Solution Examine the message(s) that accompany...
Oracle Error Message CLSGN-00211: OCR batch operation failed. string Reason for the Error Setting a set of Oracle Cluster Registry...
Oracle Error Message CLSGN-00210: failed to get value for OCR key “string”. string Reason for the Error It was not...