注册

oracle11.2.0.4迁移一条记录到达梦,连接尚未建立或已关闭

小灰灰_oO 2024/02/06 558 1

image.png
使用上面版本的DTS从oracle迁移一张表,里面就一条数据,迁移不过来。
image.png

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的驱动了,也失败。

回答 0
暂无回答
扫一扫
联系客服