AllExperts > Oracle 
Search      
Oracle
Volunteer
Answers to thousands of questions
 Home · More Oracle Questions · Answer Library  · Encyclopedia ·
More Oracle Answers
Question Library

Ask a question about Oracle
Volunteer
Experts of the Month
Expert Login

Awards

About Us
Tell friends
Link to Us
Disclaimer

 
 
 
 
About 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
OCP - SQL and PL/SQL
Brainbench certifications in Oracle Administration, PL/SQL, Developer 2000

 
   

You are here:  Experts > Computing/Technology > Oracle > Oracle > Csv data into oracle

Oracle - Csv data into oracle

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


Add to this Answer   Ask a Question


 
User Agreement | Privacy Policy | Kids' Privacy Policy | Help
Copyright  © 2008 About, Inc. AllExperts, AllExperts.com, and About.com are registered trademarks of About, Inc. All rights reserved.