创建
create materialized view mv_bjsctj_day(物化视图名) refresh force on demand start with sysdate next to_date(concat(to_char(sysdate+1,'dd-mm-yyyy'),'01:01:01'),'dd-mm-yyyy hh24:mi:ss' ) as +sql (此视图代表每天一点执行sql)
删除
drop materialized view mv_bjsc_yidiantj_day_gbyorgan(物化视图名)