Re: [Q] Distributed instance queries?

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.

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.