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 /