Multiple Databases Data Transfer

From: Joao Ricardo B Oliveira <jricardo_at_ipb.pt>
Date: Tue, 29 Jun 1999 15:25:25 +0100
Message-ID: <7lakki$ehr$1_at_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 - 16:25:25 CEST

Original text of this message