Re: Data Base Files

In article <7bf9q4$2u0_at_bgtnsc01.worldnet.att.net>,   "T. Kao" <tsaikao_at_worldnet.att.net> wrote:
> I am new to Personal Oracle 8. Can someone tell me where oracle store all
> those data that I entered into a Table, etc. ? Under what directory is the
> data base data file, control files etc are stored?
> Thanks.
>

You can use SQL to find where all of your files are:

DATABASE FILES: select * from dba_data_files;

CONTROL FILES: select * from v$controlfile;

REDO LOG FILES: select * from v$logfile;

PARAMETER FILE: select * from v$parameter where name = 'ifile';

BACKGROUND DUMP FILES: select * from v$parameter
where name in ('background_dump_dest','core_dump_dest','user_dump_dest');

Best regards,

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 265+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->             http://homepage.interaccess.com/~akaplan          <->
<->                                                               <->
<->             email: akaplan_at_interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->


-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own