Illustration repln077.gif shows a flowchart for performing a fast refresh:

  1. If the materialized view is updatable, push the materialized view deferred transaction queue to update the master table. This step can also be performed separately using the DBMS_DEFER_SYS.PUSH function.
  2. Use the materialized view log to identify changes made to the master table.
  3. Propogate identified changes to the materialized view.
  4. End fast refresh.

If the materialized view is not updatable, follow steps 2-4 above.