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 Peter Choi
Expertise
I am a senior Oracle DBA, PeopleSoft Administrator and Project Manager with 10+ years experience. I have been working with PeopleSoft (HRMS 5, 7, 7.x and 8.9), Oracle RDBMS (7.3 - 11gR1) on various Unix and Windows platforms, and some Oracle Application Server (9i/10gR2). I also have experience with the configuration and administration of BEA`s Tuxedo and WebLogic for PeopleSoft 8.x.

 
   

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

Oracle - Csv data into oracle

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.

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.