学海无涯学海无涯

I am a slow walker,
but i never walk backwards.

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
本原创文章未经允许不得转载 | 当前页面:学海无涯 » oracle查看表空间对应的物理文件名

评论