Complete Manual Refresh for Materialized Views in Oracle

 When a materialized view is refreshed ON DEMAND, one of four refresh methods can be specified as shown in the following table. You can define a default option during the creation of the materialized view.

BEGIN
    dbms_mview.Refresh('<Materialized View Name>', 'C');
    COMMIT;
END;