Description:
Starting online data bulk transfer ...
Opening output script file ...
Initializing source JDBC driver ...
Driver class oracle.jdbc.OracleDriver
Opening connection ...
Connection jdbc:oracle:thin:cir/circir@beoracle:1521:CIR
Initializing target JDBC driver ...
Driver class com.mysql.jdbc.Driver
Opening connection ...
Connection jdbc:mysql://localhost:3306/?user=root&password=8laskl
Processing schema CIR ...
Getting the number of rows of table ASSEMBLY
SELECT count(*) AS num FROM "ASSEMBLY"
ERROR: The following error occured while transfering data from ASSEMBLY
Converteren naar interne representatie is mislukt.
How to repeat:
Source is oracle table
CREATE TABLE "CIR"."ASSEMBLY" ("SYSTEMID" VARCHAR2(18 byte) NOT
NULL, "BANDRASTER" VARCHAR2(50 byte) NOT NULL, "COUPLING"
VARCHAR2(50 byte), "CROSSCONNECTOR" VARCHAR2(50 byte),
"WALLCONNECTOR" VARCHAR2(50 byte), "FLATHANGER" VARCHAR2(50
byte), "BENTHANGER" VARCHAR2(50 byte), "NONIUSHANGER"
VARCHAR2(50 byte), "SSPART" VARCHAR2(50 byte), "SSNONIUS"
VARCHAR2(50 byte),
CONSTRAINT "PK_ASSEMBLY_1" PRIMARY KEY("SYSTEMID",
"BANDRASTER")
USING INDEX
TABLESPACE "CIR"
STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
TABLESPACE "CIR" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 255
STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0)
LOGGING
CACHE
MONITORING
destination is MySQL Table
Content is :
SYSTEMID BANDRASTER COUPLING CROSSCONNECTOR WALLCONNECTOR FLATHANGER BENTHANGER NONIUSHANGER SSPART SSNONIUS
G3000 -3050 -3051 -3053 -3054 -3052 -3055 -3235
G3000 -3075 -3076 -3078 -3079 -3077 -3081 -3236
G3000 -3100 -3101 -3103 -3104 -3102 -3105 -3237 -3311 -3301
G3000 -3125 -3126 -3128 -3129 -3127 -3130 -3238 -3326 -3301
G3000 -3150 -3151 -3153 -3154 -3152 -3155 -3239 -3351 -3301
No record insert record is created in the insert.sql file
Description: Starting online data bulk transfer ... Opening output script file ... Initializing source JDBC driver ... Driver class oracle.jdbc.OracleDriver Opening connection ... Connection jdbc:oracle:thin:cir/circir@beoracle:1521:CIR Initializing target JDBC driver ... Driver class com.mysql.jdbc.Driver Opening connection ... Connection jdbc:mysql://localhost:3306/?user=root&password=8laskl Processing schema CIR ... Getting the number of rows of table ASSEMBLY SELECT count(*) AS num FROM "ASSEMBLY" ERROR: The following error occured while transfering data from ASSEMBLY Converteren naar interne representatie is mislukt. How to repeat: Source is oracle table CREATE TABLE "CIR"."ASSEMBLY" ("SYSTEMID" VARCHAR2(18 byte) NOT NULL, "BANDRASTER" VARCHAR2(50 byte) NOT NULL, "COUPLING" VARCHAR2(50 byte), "CROSSCONNECTOR" VARCHAR2(50 byte), "WALLCONNECTOR" VARCHAR2(50 byte), "FLATHANGER" VARCHAR2(50 byte), "BENTHANGER" VARCHAR2(50 byte), "NONIUSHANGER" VARCHAR2(50 byte), "SSPART" VARCHAR2(50 byte), "SSNONIUS" VARCHAR2(50 byte), CONSTRAINT "PK_ASSEMBLY_1" PRIMARY KEY("SYSTEMID", "BANDRASTER") USING INDEX TABLESPACE "CIR" STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255) TABLESPACE "CIR" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0) LOGGING CACHE MONITORING destination is MySQL Table Content is : SYSTEMID BANDRASTER COUPLING CROSSCONNECTOR WALLCONNECTOR FLATHANGER BENTHANGER NONIUSHANGER SSPART SSNONIUS G3000 -3050 -3051 -3053 -3054 -3052 -3055 -3235 G3000 -3075 -3076 -3078 -3079 -3077 -3081 -3236 G3000 -3100 -3101 -3103 -3104 -3102 -3105 -3237 -3311 -3301 G3000 -3125 -3126 -3128 -3129 -3127 -3130 -3238 -3326 -3301 G3000 -3150 -3151 -3153 -3154 -3152 -3155 -3239 -3351 -3301 No record insert record is created in the insert.sql file