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;
物化视图的建立
最新推荐文章于 2023-09-27 16:13:22 发布
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;