Finding table name for lob segment

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$$’;


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

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s