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
this site will guide you how to overcome some problems you may face during your work and guide you how to perform simple technical operations to achieve your goals.