Importing data from Oracle

[James L Genus]

I've just purchased SqlYog and am having problems downloading tables from my oracle database into a MySql database. The ODBC connection functions to allow me to connect to Oracle but fails on the creating and copying data from Oracle with a Duplicate column error. I did manage to down load once but have experienced failures since.

Why is this occuring and how do I correct it.

Thanks in advance

James L. Genus

[email protected]

[peterlaursen]

and you don't try to import a table that already exists ? (a remnant from your first successfull attempt ?)

That would be a logical explanation for the “dublicate column” error !

Did you save the job file ?? Check if there is a “drop table if exists” for the tables. I believe there isn't ?

[James L Genus]

I did not save a log of the session and cannot find one on the machine. Also, I attempted to bring over several new table with the same results. At no time during the sessions, was I presented an opprotunity to save a log file from the ODBC import wizzard.

[Ritesh]

Currently, ODBC Import Tool does not have any logging mechanism

The error simply means that you are importing duplicate rows. Empty the table in your MySQL database and re-import the data. Everything should be fine.

[James L Genus]

I've tried every thing, I know including removing all the tables from the database. SQLyog attempts to load the DDL STATEMENT several times for the same table and in the same definition statement. The duplicate error points to the DDL statement for creating the table and not in the data. I haven't found anything in the documentation that addresses this problem. I have attempted to create the SQL insert statements options. They show attempts to create the same columns several times and show the data severl times also. I don't believe this to be my error.

Thanks,

James L Genus

[email protected]

[Ritesh]

Which version of Oracle? Can you give us more info about the ODBC driver?

[James L Genus]

Oracle 9i 9.02 with Microsoft ODBC for Oracle 2.573.6200.00

[Ritesh]

We just tried with our copy of Oracle 8 and everything works great. I will ask my testing team to test it out on a 9i box.

[jhstone_china]

Ritesh wrote on May 18 2005, 04:48 AM:

We just tried with our copy of Oracle 8 and everything works great. I will ask my testing team to test it out on a 9i box.

[post=”5532″]<{POST_SNAPBACK}>[/post]

hi ,i have the same problem,pls see the attached file.oracle server is 8.1.6.the column repeated three times.

[Ritesh]

Are you sure that there is no table with the same name in a different table space? We had encountered a similar problem at our side and we fixed it by giving access to the user in only one table space.

[jhstone_china]

Ritesh wrote on Aug 8 2005, 06:08 AM:

Are you sure that there is no table with the same name in a different table space? We had encountered a similar problem at our side and we fixed it by giving access to the user in only one table space.

[post=”6795″]<{POST_SNAPBACK}>[/post]

my dbms have only one table space.

[Ritesh]

We will be releasing BETA 9 today with the bug-fix.

[Ritesh]

Did BETA 9 solve this problem?

[jhstone_china]

Ritesh wrote on Aug 9 2005, 05:52 AM:

Did BETA 9 solve this problem?

[post=”6810″]<{POST_SNAPBACK}>[/post]

yes 😀

[Author]

Posts