RE: partitioned Views - Union All
- From: "Ken Naim" <kennaim@xxxxxxxxx>
- To: <chaganti.suresh@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 23 Aug 2007 14:59:25 -0400
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Suresh Chaganti
Sent: Thursday, August 23, 2007 1:55 PM
To: oracle-l@xxxxxxxxxxxxx
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
Other related posts:
