How can I migrate data from Oracle 11gR2 database table to MySQL database table?

Question

I would like to transfer a large table from Oracle Database 11gR2 to MySQL 5.5. Anyone please suggest me how can I do it?

score 2 · Accepted Answer · answered Oct 23 '14 at 10:21

2

You can unload the data in Oracle to a text file by using Load/Unload wizards in the Oracle Database XE graphical user interface.

Then using LOAD DATA statement to load data into MySQL from that text file.

Default Setting is OK.

answered Oct 23 '14 at 10:21

Harley

1 Answers1