1SELECT e.OWNER, e.SEGMENT_NAME, e.TABLESPACE_NAME, sum(e.bytes) / 1048576 AS Megs
2FROM dba_extents e
3WHERE
4 e.OWNER = 'SCHEME_NAME' AND
5 e.TABLESPACE_NAME = 'TBS_NAME' AND
6 e.SEGMENT_NAME IN ('TABLE_NAME')
7GROUP BY e.OWNER, e.SEGMENT_NAME, e.TABLESPACE_NAME
8ORDER BY e.TABLESPACE_NAME, e.SEGMENT_NAME;