Expert: Peter Choi - 10/22/2009

Question
at present i am using mysql database
but i want to convert my whole "mysql data" into
oracle data

how to convert it please give me solution

Answer
Hi San,

Take a look here: http://download.oracle.com/docs/cd/E11882_01/doc.112/e12152/migration.htm#RPTUG4...

You may be able to use SQL DEVELOPER (Free Oracle Tool) to move your data and structure from MySQL to Oracle.

Alternatively, if you have the data in CSV format, you can pre-create the table structures in Oracle, and use Oracle's SQL LOADER tool (http://download.oracle.com/docs/cd/E11882_01/server.112/e10701/ldr_concepts.htm#...) to performa a builk load into Oracle.

Be advised if you're using Oracle for commercial use, you will need to obtain the proper software license.

Hope this helps.