请问关于ORACLE数据文件路径的问题

gargoyle · 发表于 2008-9-14 23:05

楼主思维比较混乱。

ora110 · 发表于 2008-9-14 23:12

iamclq · 发表于 2008-9-15 08:34

你是想要查表的数据在数据文件中的位置吧

Yong Huang · 发表于 2008-9-16 06:42

原帖由 lrgeid 于 2008-9-14 02:56 发表
我现在想的是查数据文件的路径,那么如果我启动ORACLE可以select * from dba_data_files或者select * from v$datafile;
这样我可以得到结果,但是dba_data_files,v$datafile这些都不是表

I still don't understand why you MUST query a table, not a view. OK. Login as sys and run

select fnnam from x$kccfn;

Yong Huang

lrgeid · 发表于 2008-9-16 10:04

好吧，那我这样问吧,我想查数据文件的路径，不管你是用视图，同义词还是表，不过要满足一个条件
select file#,block# from tab$ where obj#=(select obj# from obj$ where name=你查的对象);
只要能有结果就行了

Yong Huang · 发表于 2008-9-16 21:45

原帖由 lrgeid 于 2008-9-15 20:04 发表
好吧，那我这样问吧,我想查数据文件的路径，不管你是用视图，同义词还是表，不过要满足一个条件
select file#,block# from tab$ where obj#=(select obj# from obj$ where name=你查的对象);
只要能有结果就行了

I'm not sure if it's you or I have communication problems. Are you asking how to find the datafile, and preferably the offset inside that file, where a given object is? I already told you, dba_extents. It has file and block number. Once you know the file number, you can find its path in dba_data_files or v$datafile.

Yong Huang