cancel
Showing results for 
Search instead for 
Did you mean: 

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
emha_1
Valued Contributor

Re: database path in oracle 8i

log into your database and issue statement

select name from v$datafile;


emha.