oracle 表空间文件的位置？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/47656338/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Location of the table space files?
提问by eztam
How can I find the directory in which oracle stores it's table space files?
如何找到oracle存储其表空间文件的目录？
When I do: select * from dba_data_files;or select * from v$datafile;then I get some paths like that:
当我这样做时：select * from dba_data_files;或者select * from v$datafile;我得到一些这样的路径：
+DATA01/fu/datafile/bar_ts01_data.260.264360912
But what means +DATA01? And where is that exactly in the file system?
但什么意思+DATA01？那到底在文件系统中的哪个位置？
回答by Отгонт?гс Миймаа
+DATA01/fu/datafile/bar_ts01_data.260.264360912
+DATA01/fu/datafile/bar_ts01_data.260.264360912
Yes this is correct file path. It means you use ASM disk.
是的，这是正确的文件路径。这意味着您使用 ASM 磁盘。
After you login to OS with "grid" user [usually Oracle Grid Infrastructure installation user is named like that], run following command to browse files on ASM disk.
使用“grid”用户登录操作系统后[通常Oracle Grid Infrastructure安装用户就是这样命名的]，运行以下命令浏览ASM磁盘上的文件。
export ORACLE_HOME=/u01/app/11.2.0/grid --this is also usual installation dir, may differ on your case
export ORACLE_SID=+ASM
cd $ORACLE_HOME/bin
./asmcmd -p
ASMCMD>ls
+DATA01
+DATA02
ASMCMD>cd +DATA01
回答by Alfabravo
In that table, the file_namefield should give the full path to the datafile.
在该表中，该file_name字段应提供数据文件的完整路径。
Also, try select * from v$datafile;and that view should help as well.
此外，尝试select * from v$datafile;这种观点也应该有所帮助。
