Re: [Q] Distributed instance queries?

In article <1994Dec14.182338.15737_at_nosc.mil> vergara_at_nosc.mil (Michael P. Vergara) writes:
>From: vergara_at_nosc.mil (Michael P. Vergara)
>Subject: Re: [Q] Distributed instance queries?
>Date: Wed, 14 Dec 1994 18:23:38 GMT
 

>In article <1994Dec12.185020.7076_at_atlas.com>,
>Bruce Arbuckle <brucea_at_atlas.com> wrote:
>>In article <3c5cf7$5l_at_pipe3.pipeline.com> ddubin_at_pipeline.com (Daniel Dubinsky) writes:
>>> Does anybody know if multiple instances of Oracle are
>>>visible to each other (on the same machine or different ones on
>>>the same network)? If so, how can I select from or join to a
>>>table in another instance? Any help on the subject would be
>>>appreciated.
>>>
>>>Thanks,
>>>Dan
>>>
>>Yes they are. The method I use is to create a database link
>>between the instances and then use the select as documented in the
>>SQL reference manual
>>
>>Select [user].table[_at_databaselink] where.....
>>
>>--
>>Bruce Arbuckle EMAIL: brucea_at_adcmail.atlas.com
>>
 

>The only caution is that database links require the 'Distributed Option'
>when you are installing Oracle. Without this, no instances can reference
>any other. Take it from someone who's management said "we don't do
>distributed...whadaya mean you can't cross-communicate???" You NEED it.

You don't need the distributed option for database links. You only need it if you plan to do updates across database links. The select from a database link has been standard funtionality since version 5.

Lawrence.....

>Mike
 

>--
>============================================================================
>Mike Vergara | Be good...and you will be lonesome
>vergara_at_nosc.mil | Jimmy Buffett
>Opinions expressed are not necessarily those of anyone else but me. So there.
Received on Tue Dec 20 1994 - 11:18:10 CET