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