Run the following query as sys and post the output:
select Owner,
Segment_Name,
Segment_Type,
Bytes,
Max_Extents,
Extents
from DBA_SEGMENTS
where Segment_Type = 'TABLE'
and owner not in ('SYS','SYSTEM')
order by Owner, Segment_Name, Segment_Type, Max_Extents




Reply With Quote