Oracle database error code ORA-23472 – materialized view “string”.”string” must be atomically refreshed

Oracle Database Error Code ORA-23472 Description :
materialized view “string”.”string” must be atomically refreshed
Error Cause:
Non-atomic refresh is not supported for the specified materialized view.

How to Solve :
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.


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , ,
1 Comment   
«
»