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;
