dbms_mview.REFRESH(LIST=>'MV_CREATIVE_DCO,MV_AUTOCHECKER_UPD,MV_AUTOLINKING_DCO'/*, atomic_refresh => false, out_of_place => true*/);

begin
dbms_mview.REFRESH(LIST=>'TABLEAU.MV_CREATIVE_DCO', atomic_refresh => false, out_of_place => true);
dbms_mview.REFRESH(LIST=>'TABLEAU.MV_AUTOCHECKER_UPD,TABLEAU.MV_AUTOLINKING_DCO', atomic_refresh => false, out_of_place => true);
declare
job_is_running EXCEPTION;
PRAGMA EXCEPTION_INIT (job_is_running, -27478);
begin
dbms_scheduler.run_job('JOB_REFRESH_VISA',USE_CURRENT_SESSION=>FALSE);
exception
when job_is_running then null;
end;
end;