Change materialized view to commit

Question

I have a materialized view that I would like to change to commit (on demand) with a quick update.

However i keep getting

ora-32337 cannot alter materialized view with pending changes refresh on commit

even immediately after the update (and knowing that no changes have been made).

What could be the reason for this? MV uses external connections, maybe this is a problem? (MV journal is available for all tables)

+5

beginner_ Mar 13 '13 at 13:41

1 answer

Snow blind · Accepted Answer · 2013-07-29T13:32:40+0000

As @eaolson said, you should just drop the materialized view and recreate it as an update on commit. This is the only way.