ORA-32337: cannot alter materialized view with pending changes refresh on commit
What triggered the Error:
There are some pending changes in the detail tablesWhat should we do to fix it:
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.