oradbm的博客

今日对数据库巡检发现 ，存在100G 对象，MLOG$_T1 查询对应的注册的MVIEW SELECT * 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_OLT refresh force on demand start with to_date('15-11-2018 17:00:12', 'dd-mm-yyyy hh24:mi:ss') next sysdate+1/24 as select * 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...