用events 跟踪解决不能创建物化试图一例

核心提示： 此过程如果执行中如果提示用户无权限,需要作适当的授权. 退出SQL*Plus,在具体的目录中找到我们的 Trace 文件:[oracle@stat udump]$ ls - ltr......- rw --- 1 oracle oracle 1425501 May 13 18 : 23 s

此过程如果执行中如果提示用户无权限,需要作适当的授权. 退出SQL*Plus,在具体的目录中找到我们的 Trace 文件:

[oracle@stat udump]$ ls - ltr......- rw ------- 1 oracle oracle 1425501 May 13 18 : 23 stat_ora_1512 . trc- rw ------- 1 oracle oracle 1518962 May 13 18 : 26 stat_ora_1595 . trc- rw ------- 1 oracle oracle 1519241 May 13 18 : 27 stat_ora_1689 . trc- rw ------- 1 oracle oracle 1486910 May 13 18 : 31 stat_ora_1700 . trc- rw ------- 1 oracle oracle 943813 May 15 21 : 41 stat_ora_20358 . trc[oracle@stat udump]$ tkprof stat_ora_20358.trc SNAPSHOT.sql

查看 SNAPSHOT.sql,这回内容还算清晰,发现主要相关内容如下:

The following statements encountered a error during parse :SELECT * FROM "witsdba"."SUBSCRIPTION_TAB"@SMGR.US.ORACLE.COMError encountered : ORA - 00942----------------------------------------------------------------------------SELECT "witsdba"."SUBSCRIPTION_TAB".CURRVAL@SMGR.US.ORACLE.COM FROM DUAL@SMGR.US.ORACLE.COMError encountered : ORA - 02289----------------------------------------------------------------------------SELECT * FROM "PUBLIC"."SUBSCRIPTION_TAB"@SMGR.US.ORACLE.COMError encountered : ORA - 00942----------------------------------------------------------------------------SELECT "PUBLIC"."SUBSCRIPTION_TAB".CURRVA@SMGR.US.ORACLE.COM FROM DUAL@SMGR.US.ORACLE.COMError encountered : ORA - 02289----------------------------------------------------------------------------CREATE MATERIALIZED VIEW SUBSCRIPTION_TABBUILD IMMEDIATEREFRESH complete START WITH SYSDATE NEXT trunc( SYSDATE ) + 1AS SELECT * FROM SUBSCRIPTION_TAB@SMGR----------------------------------------------------------------------------