ORA-32337: cannot alter materialized view with pending changes refresh on commit
Cause: There are some pending changes in the detail tables
Action: Execute an on-demand refresh on the materialized view to synchronize the data between the materialized view and the detail tables and then issue an ALTER MATERIALIZED VIEW statement.
Cause: There are some pending changes in the detail tables
Action: Execute an on-demand refresh on the materialized view to synchronize the data between the materialized view and the detail tables and then issue an ALTER MATERIALIZED VIEW statement.
No comments:
Post a Comment