So i have a lob segment taking up lots of space so i need to find out the corresposding table for the lob.

SYSTEM@TEST> select count(*) from dba_lobs where SEGMENT_NAME=’SYS_LOB0000068405C00008$$’;

COUNT(*)
———-
1

Just need to query dba_lobs with the corresponding lob segment name.

SYSTEM@TEST> select OWNER,TABLE_NAME from dba_lobs where SEGMENT_NAME=’SYS_LOB0000068405C00008$$’;

OWNER                                   TABLE_NAME
—————————— ——————————
TEST                                         AUDIT_LOG