Re: Multiple Databases Data Transfer

From: chensm <chensm_at_sesrcs1.src.se.bp.com>
Date: Wed, 30 Jun 1999 15:47:39 +0800
Message-ID: <7lchng$cd11_at_eugwy1.bp.com>


Yes. Absolutely you can.
Create a dblink and use insert into t1(x,y) select a,b from table1.your_dblink;

Joao Ricardo B Oliveira wrote in message <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 Wed Jun 30 1999 - 09:47:39 CEST

Original text of this message