物化视图的建立

create materialized view 表
refresh complete on demand
start with to_date('08-03-2014 02:00:00', 'dd-mm-yyyy hh24:mi:ss') next TRUNC(SYSDATE+1)+2/24 
as
select * from 表@ERPDB;