Re: Concurrent/Parallel Execution

<mfullerton_at_gmail.com>
>I agree with Robert, cross database union is what you need. Believe it
> or not, this is not uncommon to do, and since this is theory only
> (Keeping it Simple), here is what can be done:
>
> create database links to each target database. Write a view to do you
> union:
> select my_column from my_table_at_orcl1
> union
> select my_column from my_table_at_orcl2
> union
> select my_column from my_table_at_orcl3;
>
> A better way to do this is create a data warehouse environment:
>
> create database links to each system
> create materialized views on each target table
> create a materialized view on top of all of them that has your specific
> where clause info, summaries, etc...
>

Right, but the tricky part is what I asked ORIGINALLY - Parallelism : i.e. orcl1, orcl2, orcl3 run simultaneously
So you think, "Parallel Query" is the way to achieve this ? thanks Received on Wed Nov 22 2006 - 14:07:00 CST