How to fix the Oracle error XOQ-01728: Atomic refresh is not supported.?

In this post, you’ll learn more about the Oracle ErrorXOQ-01728: Atomic refresh is not supported. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

XOQ-01728: Atomic refresh is not supported.

Reason for the Error XOQ-01728: Atomic refresh is not supported.

Cause: Multiple objects were specified in the build script, or the add_dimensions flag was set to true. Atomic refresh is not supported for builds involving two or more cube materialized views.

How to fix the Error XOQ-01728: Atomic refresh is not supported. ?

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

Action: Specify the atomic parameter as false, or build the objects individually.