RE: is it possible to execute _ALL_ of a query remotely then fetch the results over a db link?

Marc,
Have you tried embedding the query in procedure(s) on B and then executing B remotely from A? Depending on what you have to return, you may have to set up a reference cursor(s) but this technique will see the execution happen on B, the results passed to A

Bruce McCartney
DBIS
bruce.mccartney_at_dbinfosystems.com  

>
> My question is this: I have two Oracle 10g boxes, A and B. I
> create a db link from A to B. I have a select query I want
> to run from A, and every table referenced in the query lives
> on B. How can I force Oracle to just send the whole thing to
> B and then get the results?

--
http://www.freelists.org/webpage/oracle-l