oracle异常信息发生

来源:互联网 发布:微盘涨跌根据什么数据 编辑:程序博客网 时间:2024/05/01 01:47

现象:

 <@>2008-7-18 8:59:38<@>SC32244<@>200019@44A40<@>DB Access Error
     Number: -2147217900
     Source: OraOLEDB
Description: ORA-12096: error in materialized view log on "ICROP_GTMC"."TBL_TOTALHIS"
ORA-00942: table or view does not exist
        SQL: INSERT INTO tbl_TOTALHIS (dlrcd,strcd,insdid,SEQNO,CONTACTDATE,CATEGORYID,CATEGORYDVSID,vin,SERIESNA...
2<@>2008-7-18 8:59:38<@>SC32244<@>200019@44A40<@>RollBack Transaction

   解决方法:

    出现这个问题的原因是物化视图日志出了问题,只要删除该物化视图日志就解决问题,删除命令为:
  drop materialized view log on 用户名.表名;
  drop materialized view log on DB_XTWH.T_XT_DBUSERPOOLBPOL;

 

原创粉丝点击