set serveroutput on declare failures integer;begin dbms_mview.refresh_all_mviews(failures,'C','',true,false,false);dbms_output.put_line('Fail:'||failures);end;
exec dbms_mview.refresh('USER.SOME_MV','?C','',true,false,0,0,0,false,false);