Oracle Manual Materialized View Refresh
In Oracle Database, we can very easily create materialized views (MVs) and let Oracle handle the refresh automatically. I've MV with this PL/SQL. Something like create materialized view refresh complete.
411.9 KB - fxur09ov3w...ew-refresh.pdf
However, various conditions prevent the MV. The materialized view will not be refreshed with any Oracle Database refresh mechanism or packaged procedure. When you create a materialized view its refresh type is manual. This is a manual Materialized View refresh. However, you can change it to immediate. Oracle Database Performance Tuning Guide 11g.