参考资料：oracle物化视图总结
create materialized view TEMP_MV refresh complete on demand start with to_date(‘25-10-2020 23:50:00‘, ‘dd-mm-yyyy hh24:mi:ss‘) next trunc(sysdate+1,‘dd‘)+interval ‘23:50:00‘ hour to second as select * from temp
原文：https://www.cnblogs.com/iupoint/p/13985614.html