Re: Accessing the data from remote DB ?
Date: Fri, 04 Feb 2000 11:17:53 -0500
Message-ID: <krul9scb0352k9c297dcb0mtv7r0on3k4q_at_4ax.com>
A copy of this was sent to Marian ZUREK <zurek_at_cern.ch> (if that email address didn't require changing) On Fri, 4 Feb 2000 16:30:12 +0100, you wrote:
>
>
>Hi,
>
>How can I fetch data from another database, i.e. simply
>
>being logged on the database A as a user userA
>I want to select/update data on the database B as a user userB
>
when logged into database a
create database link databaseb connect to userb identified by password using 'connect_string_to_database_b';
and then
select * from T_at_databaseb
or update t_at_database set ....
>Thanks for your help.
>
>Regards,
>Marian ZUREK
>
>
>*********************************
>* Marian Zurek *
>* CERN *
>* CH-1211 GENEVE 23 *
>* e-mail: Marian.Zurek_at_cern.ch *
>*********************************
>
-- See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st Thomas Kyte tkyte_at_us.oracle.com Oracle Service Industries Reston, VA USA Opinions are mine and do not necessarily reflect those of Oracle CorporationReceived on Fri Feb 04 2000 - 17:17:53 CET