SQL> col file_name for a60;
SQL> col tablespace_name for a20;
SQL> select file_id,file_name,tablespace_name,autoextensible from dba_data_files order by file_id;
FILE_ID FILE_NAME TABLESPACE_NAME AUT
---------- ------------------------------------------------------------ -------------------- ---
1 /home/u01/app/oracle/oradata/ghsjdb/system01.dbf SYSTEM YES
2 /home/u01/app/oracle/oradata/ghsjdb/sysaux01.dbf SYSAUX YES
3 /home/u01/app/oracle/oradata/ghsjdb/undotbs01.dbf UNDOTBS1 YES
4 /home/u01/app/oracle/oradata/ghsjdb/users01.dbf USERS YES
5 /home/u01/app/oracle/oradata/ghsjdb/ghsj_xm.dbf GHSJ_XM YES
6 /home/u01/app/oracle/oradata/ghsjdb/ghsj_jcsj.dbf GHSJ_JCSJ