【 使用环境 】 测试环境
【 OB or 其他组件 】
【 使用版本 】4.2.0
报错信息如下:
但是目标端表结构已经同步过来了,如下:
如下是源端的表结构:
CREATE TABLE “DMSCNTA0”.“TD_CDMCP”
( “W1GMN2” VARCHAR2(200 CHAR),
“W1BINU” VARCHAR2(10 CHAR),
“W1TRNR” VARCHAR2(20 CHAR),
“W1TRDT” VARCHAR2(10 CHAR),
“W1IPOD” VARCHAR2(10 CHAR),
“W1DTCP” VARCHAR2(10 CHAR),
“W1RLBL” VARCHAR2(20 CHAR),
“W1RTRA” VARCHAR2(20 CHAR),
“W1TATO” VARCHAR2(20 CHAR),
“W1TERM” VARCHAR2(10 CHAR),
“W1CSTY” VARCHAR2(10 CHAR),
“W1MNDE” NUMBER(10,0) DEFAULT 0,
“W1DPTY” VARCHAR2(10 CHAR),
“W1CVF1” VARCHAR2(100 CHAR),
“W1CRSP” VARCHAR2(10 CHAR),
“W1INRT” VARCHAR2(11 CHAR),
“W1CPFQ” VARCHAR2(10 CHAR),
“W1DDWI” VARCHAR2(10 CHAR),
“W1FLRD” VARCHAR2(10 CHAR),
“W1ZWRA” VARCHAR2(20 CHAR),
“W1TWDA” VARCHAR2(20 CHAR),
“W1BPTT” VARCHAR2(20 CHAR),
“W1BTRE” VARCHAR2(20 CHAR),
“W1DPYA” VARCHAR2(20 CHAR),
“W1APAM” VARCHAR2(20 CHAR),
“W1AGBL” VARCHAR2(20 CHAR),
“W1AGOB” VARCHAR2(20 CHAR),
“TRAN_DATE” DATE,
“SEQ_NO” NUMBER(15,0) GENERATED BY DEFAULT AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE NOT NULL ENABLE,
PRIMARY KEY (“W1TRNR”, “TRAN_DATE”)
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE “ENS_DM_TBS” ENABLE
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE “ENS_DM_TBS” ;