Partition Management over rolling 180 days
I'm planning to partition a very large table with 180 days worth of rolling data -- one partition per day. What is the best way to manage the creation/deletion of partitions on a daily basis? Do I need to store/read the low/high partition names (ex., p1 and pn) so I know which to drop (p1) and what to add (pn+1)? Is there a slick alterative?
Subject
Views
Written By
Posted
Partition Management over rolling 180 days
6900
July 09, 2007 08:43AM
3597
July 26, 2007 09:55AM
3571
November 01, 2007 01:29PM
5117
November 01, 2007 06:10PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.