Re: [Q] Distributed instance queries?
From: Bruce Arbuckle <brucea_at_atlas.com>
Date: Mon, 12 Dec 1994 18:50:20 GMT
Message-ID: <1994Dec12.185020.7076_at_atlas.com>
Date: Mon, 12 Dec 1994 18:50:20 GMT
Message-ID: <1994Dec12.185020.7076_at_atlas.com>
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
Received on Mon Dec 12 1994 - 19:50:20 CET