Re: Concurrent/Parallel Execution

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Wed, 22 Nov 2006 19:05:15 +0100
Message-ID: <4sjhqoF1038q9U1@mid.individual.net>

On 22.11.2006 17:59, ihb wrote:
> "Robert Klemme"
> No, not that complicated...not JOIN,
> I try to present a very simple case....
> e.g. "select * from emp_n"
> from each DB....the requirement is to COMBINE the result sets (like UNION)

Well yes, ok then cross database union. :-)

>> Plus, you did not state your business requirements instead you come up 
>> with a solution and....

>
> I "come up with a solution" ????? <scratch-head>
>
> This is not requitrement ?
> "Say data is everywhere....there are n databases (on n servers)
> In app I need to query each DB and COMBINE the results."

Oh, it sounded to me as if you were starting to set up this system. So you have /existing/ databases you want to get data from. In that case DB links that have been suggested might be a solution.

robert Received on Wed Nov 22 2006 - 12:05:15 CST