You are here:

Oracle/Csv data into oracle

Advertisement

Expert: Suchitra Joshi - 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,

I am not sure of MySQL. But you could try a mysqldump to take backup. Basically create a customised dump that you can then use SQL-LOADER to load. You can check this link -

http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

After that you can create control files for all tables in Oracle and load data using SQL*Loader.

Hope this helps.

Regards

Suchitra

Oracle

All Answers

Answers by Expert:

Ask Experts

Volunteer

Suchitra Joshi

Expertise

I can answer questions regarding SQL, PL/SQL, Procedures, Functions, Triggers, SQL Loader, Oracle Forms, Oracle Reports, and some basic dba and performance tuning activities.

Experience

15+ years of Oracle PL/SQL Development

Education/Credentials
B.Sc (Electronics), Diploma in Computer Applications (DCA)

Awards and Honors
Oracle PL/SQL Developer Certified Associate (OCA)
Oracle Database: SQL Certified Expert
Brainbench certifications in Oracle Administration, PL/SQL, Developer 2000

©2012 About.com, a part of The New York Times Company. All rights reserved.