oracle查看表空间对应的物理文件名

查询语句：

SELECT tablespace_name,file_id,file_name,
round(bytes / (1024 * 1024), 0) total_space
FROM dba_data_files ORDER BY tablespace_name;

查询结果：

GOLDENGATE    14    /home/oracle/app/oracle/oradata/test/goldengate01.dbf    5120
SYSAUX            2    /home/oracle/app/oracle/oradata/test/sysaux01.dbf    890
SYSTEM            1    /home/oracle/app/oracle/oradata/test/system01.dbf    1500
UNDOTBS1    3    /home/oracle/app/oracle/oradata/test/undotbs01.dbf    1305
USERS            4    /home/oracle/app/oracle/oradata/test/users01.dbf    500