"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.