For partitioned tables, you may see more than one tablespace
assigned to the table name. Note that phantom usage will appear,
if the recycle bin (10g only) is not cleared.
set pagesize 500
set linesize 77
column segmentname format a35
select segmentname, tablespacename, sum(bytes/(1024*1024) ) "MB"
from dbasegments
where owner='HOLTDW' and segmentname not like 'BIN'
group by segmentname, tablespacename
order by segmentname, tablespacename ;
|
|
