Manually refreshing Oracle materialized views

Created 18 May 2006 00:00
Manual Refreshes

You can manually refresh a materialized view with the following statement:

  EXECUTE DBMS_SNAPSHOT.REFRESH('mv_your_view', 'c');

where your options are:

  • F, f - fast refresh
  • C, c - complete refresh
  • A - Always perform complete refresh
  • ? - Use the default option