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;
物化视图的建立
最新推荐文章于 2024-05-05 20:30:44 发布
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;