Finding table name for lob segment

Posted: April 12, 2012 in Objects

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

Leave a Reply

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

WordPress.com Logo

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

Google+ photo

You are commenting using your Google+ 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