Geek asks and answers

Data transfer between MySQL and Oracle databases

Here's the scenario:
I have a MySQL database and an Oracle database, and I want to do this to copy data from MySQL to Oracle on a planned basis.

The process involves simply inserting data into a table on the Oracle side, taken from a MySQL database.

Something like this: (oracle command)

insert into my_oracle_table  
select * from my_mysql_table@my_mysql_db  
where date > sysdate - 7;

What is the best practice for this? Is there any way to connect to say MySQL DB directly from an Oracle stored procedure? Maybe the other way around?

Oracle 11g and MySql 5.1

+3
source share
2 answers

Create a database link from the Oracle server to the MySQL server.

Once the database link is set, you can use the standard syntax insert into.. select from

insert into my_oracle_table  
select * from my_mysql_table@dblinkname
where date > sysdate - 7;

, , .

+1

O.D.I., Oracle Data Integrator.

http://www.oracle.com/technetwork/middleware/data-integrator/index.html

Oracle Data Integrator - , : , , SOA.

0

More articles:


All Articles