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