Re: Multiple Databases Data Tranfer

Joao,

 You could log on to ORSA and issue the following SQL statement from SQL*Plus:

 copy from scott/tiger_at_ORCL -
 insert T1 -
 using select a,b,.. from table1;

 Hope this helps.

Xuening Sun
--
Joao Ricardo B Oliveira (jricardo_at_ipb.pt) 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 Wed Jun 30 1999 - 08:33:48 CDT