sql定位过程报错_使用10046事件跟踪sql定位错误一例

修改一个表时，发生如下错误：

SQL> update emp set ename='adsf';

update emp set ename='adsf'

*

ERROR at line 1:

ORA-12096: error in materialized view log on "SCOTT"."EMP"

ORA-00942: table or view does not exist

这个提示看上去不太直观，好像是提示在物化视图日志不存在，查看一下该用户下的表：

SQL> select * from tab;

TNAME                          TABTYPE  CLUSTERID

------------------------------ ------- ----------

ASDF                           TABLE

BONUS                          TABLE

DEPT                           TABLE

EMP                            TABLE

EMPLOYEES                      TABLE

LOB_TEST                       TABLE

MLOG$_BONUS                    TABLE

MLOG$_SALGRADE                 TABLE

MLOG$_T1                       TABLE

MV_T