select values from db1 table and insert into table of DB2

Shell Programming and Scripting
1

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 in a script.

2

Create a database link between the two DBs, and do an

INSERT INTO xxx SELECT aaa FROM bbb@DB2
3

hi

i have followed this link and finished it...thanks for the help

SQL*Plus COPY Command