SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

select values from db1 table and insert into table of DB2

656319Feb 10 2010 — edited Feb 10 2010

Hi

I am having three oracle databases running in three different machine. their ip address is different. from one of the DB am able to access both the databases.(means am able to select values and insert values in to tables individually.)

I need to fetch some data from DB1 table(say DB1 ip is 10.10.10.10 and user is DB1user and table is DB1user_table) and insert the values in to DB2 table (say DB2 ip is 11.11.11.11 and user is DB2user and table is DB2user_table) from DB3 which is having access to both the DB IPs.

how do i achieve this

Edited by: Aemunathan on Feb 10, 2010 11:12 PM

This post has been answered by Walstr on Feb 10 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 10 2010

Added on Feb 10 2010

3 comments

1,593 views