unable to reclaim Free space from datafiles
Hello Oracle Gurus,
I have a tablespace where the total allocated is 11.8tb ,free space is 10TB and used space is around 1.8TB.Unable to resize/shrink datafiles using datafile resize command any further to reclaim the free space.
col TSname heading 'TSpace|Name|||'
col TSname format a25
col TSstatus heading 'TSpace|Status|||'
col TSstatus format a9
col TSSizeGB heading 'TSpace|Size|GB||'
col TSSizeGB format 999999999
col TSUsedGB heading 'TSpace|Used|Space|GB|'
col TSUsedGB format 999999999
col TSFreeGB heading 'TSpace|Free|Space|GB|'
col TSFreeGB format 999999999
col TSUsedPrct heading 'TSpace|Used|Space|%|'
col TSUsedPrct format 999999999