col tablespace_name heading 'TABLESPACE|_NAME' format a10
col file_id format 999
col file_name format a40
set linesize 132
set echo on
select f.tablespace_name,f.file_name, f.file_id, f.status file_status,
t.status tablespace_status, t.contents, t.logging
from dba_data_files f, dba_tablespaces t
where f.tablespace_name = t.tablespace_name;
set echo off
clear col

SQL> select f.tablespace_name,f.file_name, f.file_id, f.status file_status,
  2  t.status tablespace_status, t.contents, t.logging
  3  from dba_data_files f, dba_tablespaces t
  4  where f.tablespace_name = t.tablespace_name;

TABLESPACE
_NAME      FILE_NAME                                FILE_ID FILE_STAT TABLESPAC CONTENTS  LOGGING
---------- ---------------------------------------- ------- --------- --------- --------- ---------
SYSTEM    /home/human/oradata/HUMAN/system01.dbf        1 AVAILABLE ONLINE    PERMANENT LOGGING
UNDOTBS1  /home/human/oradata/HUMAN/undotbs01.dbf        2 AVAILABLE ONLINE    UNDO      LOGGING