How to claim unused space in datafile
Hello,
I have a tablespace (TS_01) that consists of 5 data files. The tablespace is housing 200+ tables but 99% of the space is used by 1 table (Table_A) storing temporary documents that get deleted the following year. I have just deleted 90% of the rows in Table_A for data older than 2005 with should free up at least 10GB of space. (the export file was 10GB for this table before the row deletion, it's 47MB now). I have moved table_A to a new tablespace TS_02 and rebuilt the indexes but the space it used on TS_01 has still not been freed up and all 5 datafiles are still 95% full. How do I reclaim the unused space ?
Thank you
Check the data dictionary
What does Oracle say is still being stored in TS_01?
i.e.:
Code:
select segment_name, bytes
from dba_segments
where tablespace_name = 'TS_01'
order by bytes