Identifying free space after deleting LOBS
Hello
Ours is a 19c database
One of the tables in our database has LOB data in it and the size of one of the tables is huge because of that. The LOB SIZE is appx 17 TB
We NULLED a bunch of LOBS based on the dates to reduce the size of the table
Before we nulled lobs
select tablespace_name,sum(bytes)/1024/1024/1024 GB from dba_segments where segment_name='SYS_LOB0013425998C00026$$' group by tablespace_name;
TABLESPACE_NAME GB
LOB_DATA 10160.9287
select sum(dbms_lob.getlength (image_rec))/1024/1024/1024 from APP_OWNER.IMAGE_REC_TAB;
SUM(DBMS_LOB.GETLENGTH(IMAGE_REC))/1024/1024/1024