SQL*Plus nicer output.

SQL> set linesize 120
SQL> col file_name for a40
SQL> col tablespace_name for a20

select file_name,tablespace_name from dba_data_files
where tablespace_name in ( select tablespace_name from dba_tablespaces where contents not in 'TEMPORARY')

FILE_NAME                                TABLESPACE_NAME
---------------------------------------- --------------------
/oradata/ora9test/system01.dbf           SYSTEM
/oradata/ora9test/undotbs01.dbf          UNDOTBS1
/oradata/ora9test/drsys01.dbf            DRSYS
/oradata/ora9test/example01.dbf          EXAMPLE
/oradata/ora9test/indx01.dbf             INDX
/oradata/ora9test/tools01.dbf            TOOLS
/oradata/ora9test/users01.dbf            USERS
/oradata/ora9test/xdb01.dbf              XDB

8 rows selected.

set linesize 120
col file_name for a40
col tablespace_name for a20