Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Modify partition range
Have a problem currently with partitioned tables.
Quick background - information warehouse database (~400gb) with
the average table size around 20 million rows. Many of these
tables are partitioned according to a year/month range (e.g.
part01 values less than 200013).
The problem is that there is a certain amount of retention of data and any records older than the required retention period can be deleted. I want to use the partitions in a round robin fashion, that is, if I only need 8 years worth of data, I only want to have 8 partitions. When a year can be rolled off, I want to re-use the partition that will now be empty (truncate it then reuse it). However, I cannot find a way to reassign the partition range value without dropping and recreating the partition with the desired range.
Has anybody run up against this problem before, and if so, what was the final solution?
Thanks,
GC
-- There is something inherently wrong with the world when Bill Gates is a famous billionaire and Dennis Ritchie lives in relative obscurity.Received on Thu May 25 2000 - 18:12:34 CDT
![]() |
![]() |