--查找使用表空间XDCDATA的TABLE,按倒序排列
SELECT SEGMENT_NAME,
PARTITION_NAME,
SEGMENT_TYPE,
BYTES / (1024 * 1024 * 1024) G
FROM USER_SEGMENTS
WHERE TABLESPACE_NAME = 'XDCDATA'
AND SEGMENT_TYPE='TABLE'
ORDER BY G DESC
SELECT SEGMENT_NAME,
PARTITION_NAME,
SEGMENT_TYPE,
BYTES / (1024 * 1024 * 1024) G
FROM USER_SEGMENTS
WHERE TABLESPACE_NAME = 'XDCIDX'
ORDER BY G DESC
SELECT SEGMENT_NAME,
PARTITION_NAME,
SEGMENT_TYPE,
BYTES / (1024 * 1024 * 1024) G
FROM USER_SEGMENTS
WHERE TABLESPACE_NAME = 'XDCIDX'
AND SEGMENT_TYPE='INDEX'
ORDER BY G DESC
SELECT SEGMENT_NAME,
PARTITION_NAME,
SEGMENT_TYPE,
BYTES / (1024 * 1024 * 1024) G
FROM USER_SEGMENTS
WHERE TABLESPACE_NAME = 'XDCIDX'
AND SEGMENT_TYPE='INDEX SUBPARTITION'
ORDER BY G DESC