Dear all,

Thanks for help.

i receive few reply for the answer as below.

Select tablespace_name, file_name from dba_data_files

or

Select name from v$datafile;


Best Regards
Terence Chua
----- Original Message -----
From: "Terence Chua"
<oracledba-ezmlmshield-x39204065.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Monday, February 11, 2008 10:46 AM
Subject: physical location of the database


> Dear All,
>
> May i know how to know where is the oracle database store in the server?(i
> mean physical location like drive D:\oracle\....)
>
> thanks for help ^_^
>
> Best Regards
> Terence Chua
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>



Oracle LazyDBA home page