COL ID FORM 999
COL FILE_NAME FORM A42
COL SEGMENT_NAME FORM A20
select a.segment_name,
A.EXTENT_ID,A.BYTES/1024 "Kb",A.BLOCKS,
a.file_id "ID",b.file_name
from dba_extents a, dba_data_files b
where a.file_id=b.file_id
and a.owner ='&OWNER' 
AND 
segment_name = '&TABLE'
ORDER BY A.EXTENT_ID
/
Hosted by www.Geocities.ws

1