Re: [Q] Distributed instance queries?

Michael P. Vergara (vergara_at_nosc.mil) wrote:
: 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.

I think distributed option allows u to do update on remote objects. W/O it, u still can reference (i.e. select) from remote objects using dblink.

Cheers.

--
===============================================================================
Jimmy CHEONG Chin Yeow				Education Data Centre
Systems Programmer				Ministry of Education
Telephone	:+65 4713949 (pager 2094375)	Kay Siang Road, S'pore (1024)	
Internet	:eio_at_moe.ac.sg               "Efficiency is <> Hard Work; 
Fax		:+65 4737513                  but = TIME MANAGEMENT"