最终解决: 需要加入表的所有列的附加日志: alter table test add supplemental log data (ALL) columns; DDL操作在生产环境较为危险, 暂缓动作 MOS文档ID:Replicat Abends With Errror ORA-01400: Cannot Insert NULL Into Table for Not Null Columns When Specifying INSERTALLRECORDS (文档 ID 1994869.1) REPLICAT...
About GoldenGate synchronization error (OGG-01004) Environmental composition:Source sideOS: NonStopServerDB: NonStop SQL / MPOGG-12.2.0.2CharctorSet: shiftjisTarget sideOS: LinuxDB: PostgreSQL 11.3OGG-12.2.0.2.181009CharctorSet: UTF-8Event:When we registered the ShiftJIS code double-byte ...
a9,:a10,:a11,:a12)>. 2020-04-24 13:48:09 WARNING OGG-01004 Aborted grouped transaction on 'FS.T_TX_ODR_SM', Database error 1438 (OCI Error ORA-01438: value larger than specified precision allowed for this c olumn (status = 1438), SQL <INSERT INTO "FS"."T_TX_ODR_SM" ("ID"...
a9,:a10,:a11,:a12)>. 2020-04-24 13:48:09 WARNING OGG-01004 Aborted grouped transaction on 'FS.T_TX_ODR_SM', Database error 1438 (OCI Error ORA-01438: value larger than specified precision allowed for this c olumn (status = 1438), SQL <INSERT INTO "FS"."T_TX_ODR_SM" ("ID"...
2020-04-24 13:48:09 WARNING OGG-01004 Aborted grouped transaction on 'FS.T_TX_ODR_SM', Database error 1438 (OCI Error ORA-01438: value larger than specified precision allowed for this c olumn (status = 1438), SQL <INSERT INTO "FS"."T_TX_ODR_SM" ("ID","NAME","BATCH_NO","CO...
源数据库: oracle 19c ogg Version 19.1.0.0.4 目标数据库: TIDB 4.0.XX OGG Version 19.1.0.0.3 安装及配置步骤参照 https://book.tidb.io/session4/chapter5/from-oracle-to-tidb.html 初始化数据报错 2021-05-10 17:57:46 WARNING OGG-03006 Source database character set or Target client character...