Home arrow Technical Tips arrow Oracle arrow Oracle Materialized View Manual Refresh
Oracle Materialized View Manual Refresh Print E-mail
Following is the call that can be made to refresh your materialized view in Oracle manually:

execute DBMS_SNAPSHOT.REFRESH('[MV_NAME]','[refresh_option]');

Refresh Options
? - Uses default
F or f - Fast
C or c - Complete
A - Always complete