How to find a table which is associated with LOBSEGMENT
610916Feb 2 2009 — edited Feb 2 2009Hi:
I am on 10.2.0.3.
Some of my tables have columns of BLOB data type. I need to shrink some BLOBs.
How to identify a table associated with a given LOBSEGMENT - say the one which has a size of 13G on my extract below?
Any advise is highyly appreciated.
1 select segment_name,segment_type,
3 blocks,bytes/1024/1024
4 from dba_segments where owner='TIBBC'
5* and segment_type='LOBSEGMENT'
SQL> /
SEGMENT_NAME SEGMENT_TYPE BLOCKS BYTES/1024/1024
---------------------------------------- ------------------ ---------- ---------------
SYS_LOB0000063995C00004$$ LOBSEGMENT 8 .0625
SYS_LOB0000063546C00014$$ LOBSEGMENT 1664 13
SYS_LOB0000063560C00015$$ LOBSEGMENT 8 .0625
SYS_LOB0000063570C00016$$ LOBSEGMENT 8 .0625
SYS_LOB0000063577C00010$$ LOBSEGMENT 8 .0625
SYS_LOB0000063577C00011$$ LOBSEGMENT 8 .0625
SYS_LOB0000063577C00012$$ LOBSEGMENT 8 .0625