Materialized Views : Refreshing a materialized view | Subtopic

• refresh type and refresh interval can be specified while creating.
• fast, complete, never or force
• manual refresh >> use DBMS_MVIEW.REFRESH

• EXECUTE DBMS_MVIEW.REFRESH('view_name','p')
• c-complete; f- fast; p- fast using pct; ? - force




•  DBMS_MVIEW.REFRESH_ALL_MVIEWS; refresh all mviews one by one.

• ALTER MATERIALIZED VIEW mviewname; 
• DROP MATERIALIZED VIEW mviewname;