Re: Tablespace shrink, HWM, interval partitionig
From: Yechiel Adar <adar666_at_inter.net.il>
Date: Thu, 31 Mar 2011 11:47:02 +0200
Message-id: <4D944D96.3040309_at_inter.net.il>
Due to the small amount of data I think that allocating a new, smaller, tablespace and finding a window to move the partitions to a new tablespace is an option, but you live there, I do not. I think it depends about the total number of partitions, but in your case I would try to allocate a new, smaller, tablespace and change the table definition to allocate the new partitions in the new tablespace. Over time this will empty out the old tablespace.
Date: Thu, 31 Mar 2011 11:47:02 +0200
Message-id: <4D944D96.3040309_at_inter.net.il>
Due to the small amount of data I think that allocating a new, smaller, tablespace and finding a window to move the partitions to a new tablespace is an option, but you live there, I do not. I think it depends about the total number of partitions, but in your case I would try to allocate a new, smaller, tablespace and change the table definition to allocate the new partitions in the new tablespace. Over time this will empty out the old tablespace.
Yechiel Adar
Israel
On 28/03/2011 11:34, Stefano Cislaghi wrote:
> Hi all,
>
> I'm experiencing a problem with a tablespace.
> In this tablespace there's only a table with 30 partitions with a
> total size of about 5gb.
> The table uses interval partitiong to create a new partition for each day.
> Old partitions are removed with ALTER TABLE ... DROP PARTITION ...
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 31 2011 - 04:47:02 CDT