查询大字段对象脚本
- SELECT A.TABLE_NAME,
- A.COLUMN_NAME,
- B.SEGMENT_NAME,
- B.SEGMENT_TYPE,
- B.TABLESPACE_NAME,
- B.BYTES / 1024 / 1024,
- B.BLOCKS,
- B.EXTENTS
- FROM USER_LOBS A, USER_SEGMENTS B
- WHERE A.SEGMENT_NAME = B.SEGMENT_NAME
- ORDER BY B.BYTES DESC;
posted @ 2017-04-07 08:58 My Data Support 阅读(166) 评论(0) 收藏 举报
