Oracle import problems…

[nicsmr]

Hello,

I'm trying the demo package to see if I can use it to convert and ORACLE db to MYSQL using an odbc system DSN.

I ask for a script file to be created and when it completes, the script shows that in the table creation part, the table structure has been duplicated and upon further investigation, in the insert part the data has been duplicated also.

When i run the script file as a batch job, it errors out saying that there is a duplicate field, that how I found out the problem.

Any one else run accross this? Any solutions to this problem out there?

below is a sample table creation code…

create table `YOG_samp`.`LAB_SAMPLE` (

`CONTRACT_ID` varchar (8) NOT NULL ,

`SAMP_NO` decimal NOT NULL ,

`TEST_TYPE` varchar (10) NOT NULL ,

`RETEST_OF_SAMP_NO` decimal NULL ,

`SAMP_DATE_TIME` char (25) NULL ,

`BILLING_RUN` decimal NULL ,

`STATION` varchar (8) NULL ,

`LOCATION` blob (1024) NULL ,

`REMARKS` blob (1024) NULL ,

`LAST_MOD_DATE` char (25) NULL ,

`PROJECT_ID` varchar (10) NULL ,

`SAMPLE_CATEGORY` varchar (10) NULL ,

`BILLING_RUN_DATE` char (25) NULL ,

`CONTRACT_ID` varchar (8) NOT NULL ,

`SAMP_NO` decimal NOT NULL ,

`TEST_TYPE` varchar (10) NOT NULL ,

`RETEST_OF_SAMP_NO` decimal NULL ,

`SAMP_DATE_TIME` char (25) NULL ,

`BILLING_RUN` decimal NULL ,

`STATION` varchar (8) NULL ,

`LOCATION` blob (1024) NULL ,

`REMARKS` blob (1024) NULL ,

`LAST_MOD_DATE` char (25) NULL ,

`PROJECT_ID` varchar (10) NULL ,

`SAMPLE_CATEGORY` varchar (10) NULL ,

`BILLING_RUN_DATE` char (25) NULL ,

PRIMARY KEY ( `CONTRACT_ID`, `SAMP_NO`, `TEST_TYPE` )

);

thanks,

Nick

[Author]

Posts