is it possible to execute _ALL_ of a query remotely then fetch the results over a db link?
- From: Marc Slemko <identd@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 10 Feb 2005 02:13:58 -0800
Ok, I've searched around a bunch. Found a bunch of threads on
metalink with no real answer other than hacks such as creating a view
on the remote server and selecting from that, which are an inane
solution.
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?
The particulars of the query really shouldn't matter... as long as
every table involved is on B. The DRIVING_SITE hint doesn't do it.
Using a collocated inline views (as the Oracle docs call it) doesn't
do it. Using NO_MERGE doesn't seem to do it.
Sure, the select query is slightly hairy. But it is all accessing
data on B, scanning through a bunch of data, and returning 10 rows or
so.
I'm just looking for confirmation about if I am missing some easy
answer here, or if it really has to be hacked together on the
specifics of each query.
What we are really looking for here is the ability to access a data
warehouse (ie. complex queries, lots of joins, but few rows returned)
remotely over a database link to allow execution from something like
htmldb living on a remote server without having to worry about hand
tuning each query for the remote execution.
Thanks.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
