ORA-12096 错误，物化视图

2019独角兽企业重金招聘Python工程师标准>>>

E Fri Nov  4 13:47:52 2016  
    =ORA-12096: error in materialized view log on "xxxx"."xxxxxT"
ORA-01653: unable to extend table xxxxx.MLOG$_xxxxxx by 32 in tablespace xxxxx
    "insert into xxxxxxxxxt ( xxxxxxx

1、查询物化视图方法

select MASTER, LOG_TABLE from USER_MVIEW_LOGS

参考博文：

http://stackoverflow.com/questions/14457791/how-to-determine-whether-a-table-is-used-to-store-materialized-view-logs

2、drop物化视图

The following statement drops the materialized view log on the oe.customers master table:

DROP MATERIALIZED VIEW LOG ON customers;

参考https://docs.oracle.com/cd/B14117_01/server.101/b10759/statements_8020.htm

转载于:https://my.oschina.net/u/2308739/blog/781737