Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2006

    Unanswered: exporting the data from oracle to mysql steps ?

    Wanted to export the data sittiing in oracle to mysql database .

    Q 1> Is it possible on Oracle ?/ withot third party tool

    Q 2> If Yes what are the steps.. ?


  2. #2
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 5
    How large is your Oracle database?

    I don't know what tool is available in MySQL to IMPORT data into it; I *hope* there is a way to load a CSV file. If so, you might try with creating CSV files from Oracle database (either SPOOLING a SELECT statement result or using UTL_FILE) and load them into MySQL. This approach wouldn't require any 3rd party tool.

    However, CSV file does NOT containt CREATE TABLE / INDEX / CONSTRAINT /PROCEDURE / ... statements - you'd have to do it using some other way (you didn't say whether you need to do that or not; perhaps MySQL already contains those tables, but they are empty) (research DBMS_METADATA package).

  3. #3
    Join Date
    Mar 2006
    hi thanks for the reply

    - My Oracle database is around 3GB.

    - wanted to create the tables / all objects as it is in Oracle db in to mysql (migrate) for the application any suggestion how to go ahead what i understood is there is a way to load the csv file (spooling the data) what are the exact steps for doing so ?will it create the tables/sp's /all objects as well?

  4. #4
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    What happens to Oracle datatypes which do not exist within MYSQL?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts