Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2003
    Posts
    5

    Unanswered: how to export a table in oracle to mysql?

    hi all, i'm a noob in oracle; i would like to know how can i export a table from oracle so that i can import it in mysql?

  2. #2
    Join Date
    Oct 2003
    Location
    St.Louis,MO
    Posts
    120
    http://www.dbforums.com/t975478.html

    I'm not familiar with mysql but follow the leads on how to create a .csv file containing you data and use that .csv to import into mysql.
    I would be suprised if mysql didn't have the ability to import a .csv

  3. #3
    Join Date
    Dec 2003
    Posts
    5
    i'm sorry but i dont understand a thing in that thread...

  4. #4
    Join Date
    Nov 2003
    Location
    Rotterdam, Netherlands
    Posts
    127
    Export the data into a text file from ORACLE
    and the import the same in MYSQL

    I am sure mysql will have capability to import text file.

  5. #5
    Join Date
    Dec 2003
    Posts
    5
    i've tried that one, but mysql gave out an error msg, something about expected ". i'll post details later when i'm at the office.

    the problem i'm having right now is on how to use the oracle interface to export the table to something mysql understand.

  6. #6
    Join Date
    Dec 2003
    Location
    Noida, India.
    Posts
    171
    You can extract the data to text file with columns separated by comma or a tab or any other character. This text file can be read by mysql.

    Extraction can be done like this:

    SQL>set heading off
    SQL>set pages 0
    SQL>set feedback off
    SQL>set echo off
    SQL>set linesize n
    --
    n is the number that you have to specify depending the maximum length a record that is extracted.
    --
    SQL>set colsep ','

    SQL>spool c:\data.txt
    SQL>select * from table_name;
    SQL>spool off








    Originally posted by b3njo
    i've tried that one, but mysql gave out an error msg, something about expected ". i'll post details later when i'm at the office.

    the problem i'm having right now is on how to use the oracle interface to export the table to something mysql understand.
    Oracle can do wonders !

Posting Permissions

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