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 ?
no, oracle says that it's in TS_02, the correct size is also being reported in OEM or SQL statement. I don't think the issue is with the table not releasing the space. I have dropped the table but the space has still not been freed up. I can move other tables and space have been freed for those but not for table_a, and like I said table_a was the largest and used up 99% of all available space.