oracle简单物化视图

--创建物化视图在每天16:00进行刷新
create materialized view MV_WDX_A build deferred refresh force on demand start with sysdate next
to_date(concat(to_char( sysdate+1,'dd-mm-yyyy'),'16:00:00'),'dd-mm-yyyy hh24:mi:ss') as
select * from t_wdx_a; 

--修改物化视图刷新时间
alter materialized view MV_WDX_A refresh force on demand start with sysdate 
next to_date(concat(to_char(sysdate+1,'dd-mm-yyyy'),' 16:25:00'),'dd-mm-yyyy hh24:mi:ss');

--删除物化视图  
drop materialized view MV_WDX_A; 

--查询物化视图刷新时间
SELECT mview_name, last_refresh_date, fullrefreshtim, increfreshtim FROM dba_mview_analysis