How to import a .dmp file (Oracle) into MySql DB?

mysql import export clob
ScienceFriction picture ScienceFriction · Nov 3, 2009 · Viewed 33.1k times · Source

The .dmp is a dump of a table built in Oracle 10g (Express Edition) and one of the fields is of CLOB type.

I was trying to simply export the table to xml/csv files then import it to the MySql, but the export simply ignored the CLOB field... (I was using sqldeveloper for that).

I noticed this post explaining how to extract the CLOB to text file but it seems to miss the handling of the other fields or at least the primary key fields. can it be adopted to create a csv of the complete table? (I am not familiar with plsql at all)

As the brute force approach, I can use my python interface to simply query for all the records and spool it to a flat file but I'm afraid it will take a LOOOONG time (query for all records replace all native commas with the ascii... )

Thanks guys!

Answer

longneck picture longneck · Nov 3, 2009

if you can get the mysql server and the oracle server on the same network, you might want to look at the mysql administrator tools, which includes the migration toolkit. you can connect to the oracle server with the migration toolkit and it will automatically create tables and move data for you.

Related questions

How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More
How can I import a database with MySQL from terminal?

How can I import a database with mysql from terminal? I cannot find the exact syntax.

Read More
Import SQL file into mysql

I have a database called nitm. I haven't created any tables there. But I have a SQL file which contains all the necessary data for the database. The file is nitm.sql which is in C:\ drive. This file has …

Read More