Database Administration (MOSC)

MOSC Banner

unable to reclaim Free space from datafiles

edited Sep 14, 2024 6:00PM in Database Administration (MOSC) 9 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center