col segment_name format a23
col tablespace_name heading 'TABLESPACE|_NAME' format a10
col header_file heading 'HEADER|_FILE' format 9999
col header_block heading 'HEADER|_BLOCK' format 9999
col file_name format a40
set linesize 132
select s.segment_name, s.tablespace_name, t.status, s.header_file, s.header_block, d.file_name
from dba_segments s, dba_data_files d, dba_tablespaces t
where  d.file_id = s.header_file
and  s.tablespace_name = t.tablespace_name
and s.owner = 'HR'
/