Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

OCI-23472

materialized view "string"."string" must be atomically refreshed

Cause

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


Action

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.