Export MySQL data and import in Oracle

Este forum é destinado a perguntas relacionadas a Oracle, mas que não se enquadram nos forums acima. Aqui serão tratadas também sobre outras tecnologias da oracle, como o Workflow, BPEL, Spatial, OCS, etc.
Post Reply
givams
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 4
Joined: Tue, 10 Apr 2012 2:31 pm

Good afternoon,
What is the best procedure for exporting data from a MySQL table (versao 1.3), for an Oracle 10G Version table)?
The table I want to export has almost 300,000 lines.
Thanks.
User avatar
stcoutinho
Moderador
Moderador
Posts: 850
Joined: Wed, 11 May 2011 5:15 pm
Location: são Paulo - SP

OI,

There are some possibilities:
a) You could generate a text file (CVS or delimited) in this MySQL table and then make a load via SQL * Loader in Oracle;

b) You could use the Oracle SQLDeveloper tool and migrate this MySQL table to Oracle. More Details You can find here: http://www.oracle.com/technetwork/datab ... 93223.html
c) Use a conversion tool, such as DRPU. More information on: http://www.drpudatabase.com/

and) Create a DBLink in Oracle pointed to MySQL and pull the table there. It has a good article in this link: http://www.devmedia.com.br/acessando-ou ... odbc/13124
Options is that they are not lacking. You need to see if you just need to migrate once the table or will be a periodic process. If it is a continuous action, you can use for example the A / E options (automating the process).

Hugs,

Sergio Coutinho
givams
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 4
Joined: Tue, 10 Apr 2012 2:31 pm

Valeu Sergio, I used Opcao B.
Hugs,
Givanildo
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 6 guests