lob字段的缩小
958902Dec 2 2012 — edited Dec 2 2012表的空间占用的 比较的
查询了 app_vip用户的占用空间
select segment_name,owner,sum(bytes)/1024/1024 "Space(MB)"
from dba_segments where owner='APP_VIP'
group by segment_name,owner order by "Space(MB)" desc
1 SYS_LOB0000109151C00005$$ APP_VIP 294688
2 SYS_LOB0000165827C00005$$ APP_VIP 70522
3 SYS_LOB0000154811C00008$$ APP_VIP 24231
其中SYS_LOB0000109151C00005$$的字段为294688M 这个字段是哪张表上面的？能缩小吗