begin
   dbms_refresh.refresh('"XX"."MVIEW_MV"');
end;

begin
   for rec in (select am.mview_name
               from all_mviews am
               where upper(am.owner) = 'XX'
                     and upper(am.mview_name) = 'MVIEW_MV'
               order by am.mview_name)loop
       execute immediate 'drop materialized view '||rec.mview_name;
       dbms_output.put_line('Materialized view '||rec.mview_name||' is deleted!');
   end loop;
end;
/
PROMPT Creating MView MVIEW_MV...
create materialized view mview_mv
build immediate refresh force
start with to_date(to_char(sysdate,'dd.mm.yyyy') || '12:00:00','dd.mm.yyyy hh24:mi:ss') next (to_date(to_char(sysdate,'dd.mm.yyyy') || '12:00:00','dd.mm.yyyy hh24:mi:ss') + 1) as
         select *
from table1
/