set wrap off
set line 132
col file_name for a40
select ts.tablespace_name, df.file_name, df.file_id, df.status
from dba_tablespaces ts,
(select tablespace_name, file_id, file_name, status
from dba_data_files
union all
select tablespace_name, file_id, file_name, status
from dba_temp_files) df
where ts.tablespace_name = df.tablespace_name
set line 132
col file_name for a40
select ts.tablespace_name, df.file_name, df.file_id, df.status
from dba_tablespaces ts,
(select tablespace_name, file_id, file_name, status
from dba_data_files
union all
select tablespace_name, file_id, file_name, status
from dba_temp_files) df
where ts.tablespace_name = df.tablespace_name