Oracle数据库管理-清除物化日志

今日对数据库巡检发现 ，存在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 删除物化日志

 drop materialized view log  on fm.T1;

3 创建物化日志

 create materialized view log on fm.t1 ;  select * from  fmdb.MLOG$_T1;

删除物化视图

 drop materialized VIEW OPERATION.MV;

创建物化视图

CREATE MATERIALIZED VIEW OPERATION.MV REFRESH FAST ON DEMAND START WITH sysdate NEXT SYSDATE+ 1/17280  AS SELECT STATEMENT@app;