Re: Multiple Databases/Multiple Instances

From: Jeff Smith <spamnadajsmith_at_provide.net>
Date: Mon, 30 Aug 1999 08:18:24 -0400
Message-ID: <37CA7690.972A19DA@provide.net>

Look into using a data base link. Your TNSNames needs to be configured to access each db (which it sounds like it does) and you will need to create the link. Then it is a simple statement as in any other.

You will reference the remote database using '@remotedbname' as defined in you db_link.

This is fairly straight forward, consult you documentation for exact syntax.

Good luck,
Jeff

Steven R Fuller 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
>
> ------------------------------------------------------------------------
>
> srfuller_at_doitnow.com <srfuller_at_doitnow.com>
>
> srfuller_at_doitnow.com
> <srfuller_at_doitnow.com>
> Netscape Conference Address
> Netscape Conference DLS Server
> Additional Information:
> First Namesrfuller_at_doitnow.com
> Version 2.1
Received on Mon Aug 30 1999 - 07:18:24 CDT