完全一样的表,完全一样的字符集.出现这样的错误...是不是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"