tablespace shrink
Hi,
I have a tablespace that is proving a challenge to reclaim disk from!!
How do I go about reclaiming the empty space below? I was thinking moving the largest object to a new tablespace would produce a lot of datafiles with zero extents used, dropping those datafiles. The large object moved accounted for 90% of the 10T now free. (dropped a few partitions)
TABLESPACE MAX_SIZE_GB USED_SIZE_GB TOTAL_USED_GB Total Free GB Used Percentage
------------------------------ -------------- ------------------- --------------------- ------------------------ ------------------ -------------------
HCP_DATA_COVERAGE 2,240.0 2,070.1 1,325.1 914.9 59
HCP_DATA 19,104.0 17,992.2 8,349.2 10,754.8 44
-------------- -------------- -------------- --------------
sum 21,344.0 20,062.3 9,674.3 11,669.7
I'm hoping there is some other option than to move all the remaining objects as we are short on disk.