RE: partitioned Views - Union All

The benefits of oracle partitioning is that you do not need to move the data to another database, you can keep it in the same database (on different storage if necessary) and have query flexibility.  

Ken  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Suresh Chaganti
Sent: Thursday, August 23, 2007 1:55 PM
To: oracle-l_at_freelists.org
Subject: partitioned Views - Union All  

Hello  

I may have to move some historical data to a different database, while retaining flexbillity to query on demand.  

Partitioned Views seem to be perfect option with UNION ALL views where the optimizer is smart about not going to remote DB if it doesnt need to.  

But I am concerned about Rule Set for Union All view which practically defeats the whole purpose.  

More confusing is Oracle's statement to use partitioned Tables starting from Oracle 8 instead of Partition views. In the scenario I described above, obviously partitioned view is the way to go.  

Here is the link for any one interested

http://download-west.oracle.com/docs/cd/A58617_01/server.804/a58246/distrib. htm#8451  

Has any one implemented this feature. Please respond with any tips, hidden parameters  

thanks
Suresh

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