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 ...
-- //www.freelists.org/webpage/oracle-l