goldengate ORA-12899: value too large for column

来源：互联网发布：大学生手机号数据库编辑：程序博客网时间：2024/06/04 20:33

完全一样的表,完全一样的字符集.出现这样的错误...是不是bug来的?

2015-05-20 11:25:45 INFO OGG-00957 Oracle GoldenGate Manager for Oracle,mgr.prm: Purged old extract file/oggdata/fbi_ggt1/dirdat/gc065393, applying UseCheckPoints purge rule: OldestChkpt Seqno 65561 > 65393.

2015-05-20 11:12:52 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle,003rpmp.prm: PROCESS ABENDING.

2015-05-20 11:12:52 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle,003rpmp.prm: Error mapping fromFBI.CSM020 to FBI.CSM020.

有个column vach2 100 不知道为什么source能插入105,target 就出错了.

把target改成105就好了.

source

CREATE TABLE "FBI"."CSM020"
( "ACCT_NO" VARCHAR2(8),
"CONT_NO" VARCHAR2(3),
"DATE_TIME_CRTE" DATE DEFAULT sysdate,
"SEQU_NO" VARCHAR2(6),
"NOTE_LINE" VARCHAR2(100),
"SYST_GENE_YN" VARCHAR2(1),
"LAST_UPDT_USER" VARCHAR2(20),
"LAST_UPDT_DATE" DATE,
"ALTER_MSG_INDC" VARCHAR2(1),
"NOTE_TYPE" VARCHAR2(40)
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 2147483648 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "CSM020_DATA"

target

SQL> select CHAR_USED,CHAR_LENGTH from dba_tab_columns

where owner='FBI' and table_name='CSM020' and column_namein ('NOTE_LINE'); 2

C CHAR_LENGTH

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

B 100

1 row selected.

SQL> Select dbms_metadata.get_ddl('TABLE','CSM020','FBI') from dual;

DBMS_METADATA.GET_DDL('TABLE','CSM020','FBI')
--------------------------------------------------------------------------------

CREATE TABLE "FBI"."CSM020"
( "ACCT_NO" VARCHAR2(8),
"CONT_NO" VARCHAR2(3),
"DATE_TIME_CRTE" DATE DEFAULT sysdate,
"SEQU_NO" VARCHAR2(6),
"NOTE_LINE" VARCHAR2(105),
"SYST_GENE_YN" VARCHAR2(1),
"LAST_UPDT_USER" VARCHAR2(20),
"LAST_UPDT_DATE" DATE,
"ALTER_MSG_INDC" VARCHAR2(1),

DBMS_METADATA.GET_DDL('TABLE','CSM020','FBI')
--------------------------------------------------------------------------------
"NOTE_TYPE" VARCHAR2(40)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 2147483648 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DE
FAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "CSM020_DATA"

0 0