oracle 物化视图

create materialized view mv_cont_cust_contacts_v
refresh force on demand start with sysdate next to_date( concat( to_char( sysdate+1,'dd-mm-yyyy'),' 22:00:00'),'dd-mm-yyyy hh24:mi:ss')
as select * from cont_cust_contacts_v

posted @ 2017-12-11 16:45  albert_think  阅读(118)  评论(0编辑  收藏  举报