create materialized view ALLCANSELECTORDER
refresh complete on demand
start with to_date('30-06-2009 17:22:04', 'dd-mm-yyyy hh24:mi:ss') next sysdate+1/1440
as
select * from ALLCANSELECTORDERS
refresh complete on demand
start with to_date('30-06-2009 17:22:04', 'dd-mm-yyyy hh24:mi:ss') next sysdate+1/1440
as
select * from ALLCANSELECTORDERS
refresh complete --刷新对整个物化视图进行完全的刷新
on demand--刷新的模式on demand ,物化视图在用户需要的时候进行刷新,可以手工通过DBMS_MVIEW.REFRESH等方法来进行刷新,也可以通过JOB定时进行刷新
start with to_date('30-06-2009 17:22:04', 'dd-mm-yyyy hh24:mi:ss')--第一次刷新时间
next sysdate+1/1440 --刷新时间间隔
as
select * from ALLCANSELECTORDERS