<div>
It seems to be Visual Foxpro ...
</div>


<div>
The locations are specified during database creation by the DBA. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</div>


The locations are specified during database creation by the DBA.       

<div>
what i mean is. when the database is created where do you specify where theses files are written to?
</div>


what i mean is. when the database is created where do you specify where theses files are written to?

<div>
what i meant to say was<br />
<br />
when the database is being created what decides where the .dbf files go. is this up to the user?<br />
<br />
also<br />
<br />
if my database crashed how would i find out where these files are. is there a file that contains the location of the .dbf files or do i just need to keep a note of the location<br />
<br />
the .ctl file location &nbsp;are specified in the init.ora file, is there a file that contains the location of the .dbf files<br />
<br />
hope this is clearer now!
</div>


what i meant to say was

when the database is being created what decides where the .dbf files go. is this up to the user?

also

if my database crashed how would i find out where these files are. is there a file that contains the location of the .dbf files or do i just need to keep a note of the location

the .ctl file location  are specified in the init.ora file, is there a file that contains the location of the .dbf files

hope this is clearer now!

<div>
<div class="content wysiwyg-content">
i have found out where my .dbf files are by using<br />
<br />
select * name from v$datafile;<br />
&nbsp;<br />
/x/y/z/data.dbf<br />
<br />
what file determines where the .dbf files are written too.<br />
<br />
how do i find out what file writes the .dbf files to the location /x/y/z<br />
<br />
<br />
thanks
</div>
</div>


i have found out where my .dbf files are by using

select * name from v$datafile;
 
/x/y/z/data.dbf

what file determines where the .dbf files are written too.

how do i find out what file writes the .dbf files to the location /x/y/z


thanks

location dbf files

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.