location dbf files

i have found out where my .dbf files are by using

select * name from v$datafile;

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

Who is Participating?
go2guyConnect With a Mentor Commented:
When you create the database using dbca (database configuration assistant), there is a dialog that allows you to specify where these go.  You can either set the file location variable or specify at the individual file level where you want them to go.

As for the location of the .dbf files, you should periodically be backing up the control file to trace (ALTER DATABASE BACKUP CONTROL FILE TO TRACE), in which case the trace file goes to the udump location (which you would probably first look up in the init.ora file to see where the udump location is).  When you backup the control file to trace, it is essentially a text version of the binary control file.
Helena Markováprogrammer-analystCommented:
It seems to be Visual Foxpro ...
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

The locations are specified during database creation by the DBA.       
plennonAuthor Commented:
what i mean is. when the database is created where do you specify where theses files are written to?
plennonAuthor Commented:
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?


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!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.