The LOB segment size is 55 GB.
Query used to find the segment size
The LOB data size is 2 MB.
Query used to find the LOB data size
select sum(dbms_lob.getlength (<lob column name>)) from <table_name>;
We used to do the online re-org.
We did a shrink after the re-org using the below statement.
alter table <table name> modify lob(<lob column name>) (shrink space [cascade]);
There is nothing seen in DBA_RECYCLEBIN. As well, since the deletion was performed through application functionality, it issues an AUTO COMMIT;