使用上面版本的DTS从oracle迁移一张表,里面就一条数据,迁移不过来。
CREATE TABLE "CYH_TEST"
( "RID" NUMBER,
"KID" NUMBER NOT NULL ENABLE,
"PLANT_ID" NUMBER NOT NULL ENABLE,
"PROD_LINE_ID" NUMBER NOT NULL ENABLE,
"WORKCELL_ID" NUMBER NOT NULL ENABLE,
"CALENDAR_DAY" DATE NOT NULL ENABLE,
"SHIFT_CODE" VARCHAR2(1) NOT NULL ENABLE,
"PROD_TEAM" VARCHAR2(300),
"FACTOR_CODE" VARCHAR2(30) NOT NULL ENABLE,
"ITEM_ID" NUMBER NOT NULL ENABLE,
"TOP_MAKE_ORDER_ID" NUMBER,
"WORK_CENTER" VARCHAR2(30),
"REASON_ID" NUMBER,
"QTY" NUMBER NOT NULL ENABLE,
"AREA" NUMBER,
"CID" NUMBER,
"OBJECT_ID" NUMBER,
"REL_ID" NUMBER NOT NULL ENABLE,
"COL_DTL_ID" NUMBER NOT NULL ENABLE,
"SUMMARY_DATE" DATE NOT NULL ENABLE,
"FURNACE_TYPE" VARCHAR2(30),
"PRODUCT_TYPE" VARCHAR2(200),
"ROUGH_ITEM_ID" NUMBER,
"ROUGH_AREA" NUMBER,
"SUPPLIER_ID" NUMBER,
"CATEGORY_SEGMENT1" VARCHAR2(300),
"CATEGORY_SEGMENT2" VARCHAR2(300),
"SHIFT" VARCHAR2(30),
"SHIFT_TIME" NUMBER,
"ON_DUTY_COUNT" NUMBER,
"REPORT_BUSINESS_AREA" VARCHAR2(100),
"IS_ON_LINE" VARCHAR2(100),
"MAINDEVICE" VARCHAR2(100),
"DOMESTIC_SALE" VARCHAR2(100),
"PROD_TYPE" VARCHAR2(100)
) 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 "TEST_DATA"
数据:
INSERT INTO CYH_TEST ("RID", "KID", "PLANT_ID", "PROD_LINE_ID", "WORKCELL_ID", "CALENDAR_DAY", "SHIFT_CODE", "PROD_TEAM", "FACTOR_CODE", "ITEM_ID", "TOP_MAKE_ORDER_ID", "WORK_CENTER", "REASON_ID", "QTY", "AREA", "CID", "OBJECT_ID", "REL_ID", "COL_DTL_ID", "SUMMARY_DATE", "FURNACE_TYPE", "PRODUCT_TYPE", "ROUGH_ITEM_ID", "ROUGH_AREA", "SUPPLIER_ID", "CATEGORY_SEGMENT1", "CATEGORY_SEGMENT2", "SHIFT", "SHIFT_TIME", "ON_DUTY_COUNT", "REPORT_BUSINESS_AREA", "IS_ON_LINE", "MAINDEVICE", "DOMESTIC_SALE", "PROD_TYPE") VALUES ('702', '199783325.4', '307', '10513', '6385', TO_DATE('2017-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), 'D', '2A', 'YCL_WIP_COST', '326197', '9368443', '22部连续炉', NULL, '-1', '-1.3631964229725861199340212931281268318', '333042239', NULL, '6443', '5509', TO_DATE('2017-10-01 08:00:00', 'SYYYY-MM-DD HH24:MI:SS'), 'JC_LXL', 'A类材料.原片玻璃', NULL, NULL, '370305', 'RA', 'A', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
直接在DM里面执行insert语句可以插入,但是DTS就是迁移不成功,这什么bug?我也试着指定oracle的驱动了,也失败。
已验证,确实存在,我们反馈下。
可以用这个iso包里面的工具迁移。
链接地址:https://eco.dameng.com/s/VMQ0LDLXM8 提取码:96ue