Re: How to use 2 oracle bases at the same time ?

One way is to create a database link on one instance that connects to the other one and use that in the table spec used for the updated data e.g. .
 update this_table set this_col = select that_col from that_table_at_remotelink

hth

CEFC <cefctest_at_mail.fc-net.fr> wrote:

>I have to update a database using datas from another.
>The two bases are Oracle but in different instances.
>To do this, i would like to use PL/SQL.
>
>Can somebody help me please ?
>Many Thanks
>
>Jean-Michel, France
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Fri Jun 16 2000 - 00:00:00 CDT