Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Modify partition range

Modify partition range

From: Gregory Conron <gconron_at_hfx.andara.com>
Date: Thu, 25 May 2000 20:12:34 -0300
Message-Id: <10508.106795@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US