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

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.

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