SELECT * FROM (
SELECT
OWNER, SEGMENT_NAME, BYTES/1024/1024 SIZE_MB, SEGMENT_TYPE
FROM
DBA_SEGMENTS
WHERE
SEGMENT_TYPE = 'TABLE' -- <> 'TABLE'
ORDER BY
BYTES/1024/1024 DESC ) WHERE ROWNUM <= 10
SELECT
OWNER, SEGMENT_NAME, BYTES/1024/1024 SIZE_MB, SEGMENT_TYPE
FROM
DBA_SEGMENTS
WHERE
SEGMENT_TYPE = 'TABLE' -- <> 'TABLE'
ORDER BY
BYTES/1024/1024 DESC ) WHERE ROWNUM <= 10