Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: DB Links

Re: DB Links

From: Yechiel Adar <adar76_at_inter.net.il>
Date: Thu, 23 Sep 2004 20:05:32 +0200
Message-ID: <0e2201c4a197$ec1d66e0$c701a8c0@sys3>


I think that the result of this hint is that oracle send the sql to execute on the remote db like:
Select * from (your select)@driving_site.

I did not researched this in depth.

In my case it took the same time when I sent the query directly to the remote db.

In fact, I found the hint after I saw that it run OK on the remote site and started to look for something that will allow me to do this without having the user manually program a connect also to the remote db.

Yechiel Adar
Mehish

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 23 2004 - 12:15:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US