Re: Multiple Databases

From: Thomas Kyte <>
Date: Sat, 28 Aug 1999 19:01:10 GMT
Message-ID: <>

A copy of this was sent to Steven R Fuller <> (if that email address didn't require changing) On Sat, 28 Aug 1999 11:19:17 -0700, you wrote:

>Please Help!!!, What is the best way to pull data from one dataabse to
>I want to extract data from database 1, called prod1
>manipulate the data
>and load it onto database 2, called prod2
>Is this depenendent upon the tnsnames.ora file? At this point I have to
>from prod1 and reconnect to prod2

there are many ways.

if you are trying to do this in plsql -- have your DBA create a database link so you can query from this database. you'll be able to code:


   for x in ( select * from T_at_that_other_database ) loop


   end loop

if your needs can be statisfied with the sqlplus copy command -- all you need is a tnsnames entry. see the sql plus doc for more info.

if you are in pro*c, you can use multiple connections OR database links.

See for my columns 'Digging-in to Oracle8i'...
Current article is "Part I of V, Autonomous Transactions" updated June 21'st
Thomas Kyte         
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation
Received on Sat Aug 28 1999 - 21:01:10 CEST

Original text of this message