Re: Tablespace shrink, HWM, interval partitionig

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-l


Other related posts: