oradbm的博客

今日对数据库巡检发现 ，存在100G 对象，MLOG$_T1查询对应的注册的MVIEWSELECT * FROM DBA_REGISTERED_MVIEWS 1 取消对物化视图的注册依赖 begin dbms_mview.unregister_mview('OPERATION','MV','TXB'); END; begin dbms_mview.purge_mview_from_log('123'); END;2 删除...

1 包含子查询的物化的物化视图创建create materialized view MV_OLTrefresh force on demandstart with to_date('15-11-2018 17:00:12', 'dd-mm-yyyy hh24:mi:ss') next sysdate+1/24 asselect * from v11;CREATE OR RE...

creatematerializedviewlogont_sms_out_mob_uniwithrowid;dropmaterializedviewlog on schema.table_name;EXEC DBMS_MVIEW.REFRESH('MV_TEST2')SELECT OWNER, MASTER, MVIEW_ID FROM US...