Oracle Shrink Table - regain your space back
I believe this is better explained with an example. Sql code: lets first check if your database table spaces that re in manual and auto segment space management. SELECT tablespace_name, extent_management, segment_space_management FROM dba_tablespaces; TABLESPACE_NAME EXTENT_MANAGEMENT SEGMENT_SPACE_MANAGEMENT ------------------------------ ----------------- ------------------------ SYSTEM LOCAL MANUAL SYSAUX ...