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
albert-think 2017-12-11 16:45 原文
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