Claim back LOBSEGMENT space

After deleteing rows from a table with LOB column you will still see same number of extents and size capacity.
in order to claim back the space of the LOB SEGMENT you will need to run this command:

ALTER TABLE your_table MODIFY LOB (your lob column) (SHRINK SPACE);

validation of reclaiming the space-
Identify the segment name using this query:


select *
from DBA_LOBS
where TABLE_NAME = 'your table' and COLUMN_NAME = 'your column';

Validate the size reduction by quering DBA_EXTENTS table where SEGMENT_NAME is the SEGMENT_NAME from above query.


Good luck