Refreshing materialized views

Refreshing materialized views

In Oracle, if you specify REFRESH FAST for a single-table aggregate Oracle materialized view, you must have created a materialized view log for the underlying table, or the refresh command will fail. When creating an Oracle materialized view, you have the option of specifying whether the refresh occurs manually (ON DEMAND) or automatically (ON COMMIT, DBMS_JOB). To use the fast warehouse refresh facility, you must specify the ON DEMAND mode. To refresh the Oracle materialized view, call one of the procedures in DBMS_MVIEW.

The DBMS_MVIEW package provides three types of refresh operations:

• DBMS_MVIEW.REFRESH: Refreshes one or more Oracle materialized views

• DBMS_MVIEW.REFRESH_ALL_MVIEWS: Refreshes all Oracle materialized views

• DBMS_MVIEW.REFRESH_DEPENDENT: Refreshes all table-based Oracle materialized views