SET pages 60
SET lines 80
col owner format a15
col segment_name format a25
col tablespace_name format a15
col tot_bytes format 9,999,999,999
SELECT owner,segment_name,tablespace_name,SUM(bytes) tot_bytes
FROM dba_extents
WHERE segment_type = 'TABLE' AND
owner = UPPER('&owner_name')
GROUP BY owner,segment_name,tablespace_name
/