1. 创建物化视图
create materialized view V_MTR_STATIONEQU
refresh force on demand
start with to_date('04-06-2013 10:27:06', 'dd-mm-yyyy hh24:mi:ss') next sysdate + 3/(24*6)
as
select * from table_name;
2. 手动刷新物化视图
exec dbms_mview.refresh('v_mtr_stationequ');
3. 删除物化视图
drop materialized view V_MTR_STATIONEQU