6

I have a materialized view I would like to alter to on commit (from on demand) using fast refresh.

However I constantly get 

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

even directly after a refresh (and knowing that no change was done).

What could be the cause for this? The MV uses outer joins, could that be an issue? (MV log is available for all tables)

beginner_
  • 7,230
  • 18
  • 70
  • 127

1 Answers1

0

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

Snow Blind
  • 1,164
  • 7
  • 12
  • 3
    Be careful with just dropping the Materialized View. Remember to check for constraints on the materialized view/table otherwise you might break things without knowing. The safer choice is to perform a manual refresh and then change to refresh on commit. `DBMS_MVIEW.REFRESH('Owner.MViewName','C'); ALTER MATERIALIZED VIEW Owner.MViewName REFRESH ON COMMIT;` – bdeem Jul 01 '15 at 19:29