Re: Multiple Databases Data Tranfer

Yes it is possible. You need to Create Database Links between these(or as many) databases and refer them in the Query like this :

>Insert into tableA_at_DB_1(cols..) select * from tableB_at_DB_2;
where DB_1 and DB_2 are Database Links created using

>Create Database Link DB_2 connect to <User> identified by <password>
  using 'TNS_connect string' ;

where TNS_Connect String is defined in U'r Tnsnames.ora eg DB_2

-Thiru

Joao Ricardo B Oliveira wrote:

> hi there...
>
> i want to know if it's possible to execute DML instructions between 2
> databases like this :
> i have 2 instances for 2 databases : instance ORCL, instance ORSA
>
> ORCL
> ------
> table1
> table2
> ...
>
> ORSA
> ------
> T1
> T2
>
> INSERT INTO T1(x,y,...) --- table in ORSA
> SELECT a,b,..
> FROM TABLE1 --- table in ORCL
> ...
>
> Is this POSSIBLE ?????
>
> reply to jricardo_at_ipb.pt...
> thanks !!!!
Received on Tue Jun 29 1999 - 12:56:17 CDT