Re: Multiple Databases

A copy of this was sent to Steven R Fuller <srfuller_at_doitnow.com> (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
>another.
>
>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
>disconnect
>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:

begin

   for x in ( select * from T_at_that_other_database ) loop

      process...
      insert

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 http://govt.us.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 Corporation