Operating System - Microsoft
1748180 Members
3838 Online
108759 Solutions
New Discussion

database path in oracle 8i

 
oracle query
Occasional Contributor

database path in oracle 8i

How i will be able to see the path of database on Windows NT in oracle 8i?

whenever we create a database in 9i a folder of that database name automatically created in oradata eg.( .dbf, .ctl , .rdo files can be found in that particular folder)

like in oracle 9i is ../oradata/abc/
pls reply me
1 REPLY 1
emha_1
Valued Contributor

Re: database path in oracle 8i

log into your database and issue statement

select name from v$datafile;


emha.