软件环境 Windows NT+ORACLE
ORACLE安装路径为C:\ORANT
SQL语句
SQL> col file_name format a
SQL> select tablespace_namefile_idbytes//file_name
from dba_data_files order by file_id;
TABLESPACE_NAME FILE_ID BYTES// FILE_NAME
SYSTEM C:\ORANT\DATABASE\SYSORCLORA
USER_DATA C:\ORANT\DATABASE\USRORCLORA
ROLLBACK_DATA C:\ORANT\DATABASE\RBSORCLORA
TEMPORARY_DATA C:\ORANT\DATABASE\TMPORCLORA
