0 Replies Latest reply: Aug 20, 2013 6:48 AM by Tony Andrews RSS

    Have to refresh materialized views twice for changes to take effect

    Tony Andrews

      If I use SQL Developer to refresh a materialized view using the context menu's Refresh Option -> Force Refresh Now... with refresh type 'C' (complete), I typically find that changes to the source data are not reflected in the MV unless I repeat the refresh a second time.  Why would that be?