/* Formatted on 21/03/2018 5:00:01 PM (QP5 v5.114.809.3010) */
DECLARE
   NAM   VARCHAR2(252);
BEGIN
   FOR OUTPUT
   IN (SELECT   'dbms_refresh.refresh(''' || name || ''');'
         INTO   NAM
         FROM   all_snapshots)
   LOOP
 EXEC OUTPUT.NAM;
   END LOOP;
END;

DECLARE
v_number_of_failures NUMBER(12) := 0;
BEGIN
DBMS_MVIEW.REFRESH_ALL_MVIEWS(v_number_of_failures,'C','', TRUE, FALSE);
END;