Re: [Q] Distributed instance queries?
Date: Fri, 9 Dec 1994 12:16:33 GMT
Message-ID: <James.Lawrence.59.000C4707_at_epamail.epa.gov>
In article <3c5cf7$5l_at_pipe3.pipeline.com> ddubin_at_pipeline.com (Daniel Dubinsky) writes:
>From: ddubin_at_pipeline.com (Daniel Dubinsky)
>Subject: [Q] Distributed instance queries?
>Date: 7 Dec 1994 17:20:23 -0500
> 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
You can link them via DB links just as if they were on different machines. Selecting on tables from other instances is no problem, in fact I used to keep links between production and development instances and populate test tables by 'insert into xxx select from xxx_at_prod'. Joining can be done also, beware of optimization issues!
Lawrence..... Received on Fri Dec 09 1994 - 13:16:33 CET