Multiple Databases Data Tranfer

From: Joao Ricardo B Oliveira <jricardo_at_ipb.pt>
Date: Tue, 29 Jun 1999 15:27:41 +0100
Message-ID: <7lakoq$eij$1@pan.ipb.pt>

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 - 09:27:41 CDT