Database Error Messages

OCI-32337

cannot alter materialized view or zonemap to refresh on commit with pending changes

Cause

There were some pending changes in the detail tables.


Action

Perform on-demand refresh of the materialized view or zonemap to synchronize the data between the materialized view and the detail tables and then issue the ALTER MATERIALIZED VIEW or ALTER MATERIALIZED ZONEMAP statement.