1.

ALTER MATERIALIZED VIEW viewname REFRESH FAST

2.

BEGIN
DBMS_MVIEW.REFRESH (
list => 'viewname',
Method =>'C',
refresh_after_errors => True);
END;

第二种比较有效！