Re: Database Link Question

From: Hillel Cohen <hillyc_at_net2phone.idt.net>
Date: Wed, 30 Jun 1999 17:55:08 -0400
Message-ID: <7le3ns$8jl_at_nnrp3.farm.idt.net>


Why don't you create a view on the remote database and access the view with a link.

James W. Howe <james.howe_at_see.signature> wrote in message news:3776f0da.1425339_at_gustav...
> I'm working with a database which is linked to another database
> located on another server. We have implemented synonyms to allow
> programs to access remote tables without having to know that they
> aren't local. However, this raises a question. If I have a program
> which is performing selects and other operations on the remote table,
> will this necessarily mean that every record in the table from the
> remote database is sent over the network to our "local" machine so
> that it can be processed by the query or does Oracle have some way to
> have the query executed remotely? I would guess it's the former and
> not the latter. When working with linked databases, what is the best
> technique to keep network traffic to a minimum?
>
> Our "local" database is 8i and the "remote" database is 7.3 (I
> believe).
>
> Any help anyone can offer on this subject would be appreciated.
>
> Thanks.
Received on Wed Jun 30 1999 - 23:55:08 CEST

Original text of this message