OCI Error ORA-12096: error in materialized view log on "JTINFO"."TBL_USERID"
来源:互联网 发布:k线绘图软件 编辑:程序博客网 时间:2024/05/16 12:59
前两天进行了一次在线重定义,修改表某字段的长度。业务表,7000W左右的数据量,修改列为复合主键的其中一列,varchar2类型。
Oracle 主备两台,读写分离。使用OGG进行同步。
背景:
在主库进行在线重定义,主库顺利完成,但是在备库报出异常,异常信息如下:
OCI Error ORA-12096: error in materialized view log on "JTINFO"."TBL_USERID"ORA-12899: value too large for column "JTINFO"."MLOG$_TBL_USERID"."USID_IMEI" (actual: 36, maximum: 32) (status = 12096), SQL <INSERT /*+ APPEND */ INTO "JTINFO"."TBL_USERID" ("USID_UID","USID_IMEI","USID_IMSI","USID_FLAG","USID_ACTIVE") VALUES (:a0,:a1,:a2,:a3,:a4)>Operation failed at seqno 39201 rba 3725780Discarding record on action DISCARD on error 12096Problem replicating JTINFO.TBL_USERID to JTINFO.TBL_USERIDMapping problem with insert record (target format)...*USID_UID = 8087585692USID_IMEI = 1B200F09-11A1-4C24-A952-65475EBE116DUSID_IMSI = 000000000000000USID_FLAG = 0USID_ACTIVE = 1
于是,查找到表MLOG$_TBL_USERID,增加此列长度,然后停止报错,问题解决,网上查看有人说为Oracle BUG,目前还未进行查证。
为什么会多出来一张表MLOG$_TBL_USERID?
1 0
- OCI Error ORA-12096: error in materialized view log on "JTINFO"."TBL_USERID"
- ERROR at line 1: ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view
- ORA-12032: cannot use rowid column from materialized view log on "DCS_BIZ"."TMP_12"
- rep进程删不掉-OCI Error ORA-00942: table or view does not exist (status = 942
- ORA-01511: error in renaming log/data files
- Error 270 for archive log file ORA-00270: error creating archive log Error 1033 received logging on
- ORA-23413: table "DCS_BIZ"."TMP_12" does not have a materialized view log
- Sort aborted Error in MySQL Error Log
- goldengate OCI Error ORA-01400: cannot insert NULL
- ORA-00270: error creating archive log
- ORA-00205: error in identifying control file, check alert log for more info
- ORA-00205: error in identifying control file, check alert log for more info
- ORA-00205: error in identifying control file, check alert log for more info
- 解决案例:ORA-00205: error in identifying control file, check alert log for more info
- OCI-22053: overflow error
- ERROR OGG-00524 DDL trace log file [\ggs_ddl_trace.log], error code -20782 error message ORA-207
- Exception details are logged in Window > Show View > Error Log
- java.lang.NullPointerException Exception details are logged in Window > Show View > Error Log 正确解决方法
- 关于三星字库门,以及事后损坏轻的emmc字库修复方案(以泛泰820/810手机为例)
- 关于口令强度等级的设计
- UITableViewCell的高亮和选中状态
- 如何管理并设计你的口令
- SSE指令使用注意
- OCI Error ORA-12096: error in materialized view log on "JTINFO"."TBL_USERID"
- HBase Canary
- Remove Duplicates from Sorted List
- mysql存储空间使用观察
- 各种排序算法的实现-8(选择排序的实现)
- HBase 健康检查工具
- ORA-01003: no statement parsed
- SELF DESCRIBING NUMBERS题解
- SWAP CASE题解