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

select file_name,tablespace_name from dba_data_fileswhere 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 120col file_name for a40col tablespace_name for a20

Tags: oracle, sqlplus