Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

location dbf files

Posted on 2004-04-30
6
Medium Priority
?
2,132 Views
Last Modified: 2010-05-18
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
0
Comment
Question by:plennon
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 12

Expert Comment

by:catchmeifuwant
ID: 10958278
????
0
 
LVL 22

Expert Comment

by:Helena Marková
ID: 10958478
It seems to be Visual Foxpro ...
0
 
LVL 13

Expert Comment

by:anand_2000v
ID: 10958592
The locations are specified during database creation by the DBA.       
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 

Author Comment

by:plennon
ID: 10958868
what i mean is. when the database is created where do you specify where theses files are written to?
0
 

Author Comment

by:plennon
ID: 10959303
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!
0
 

Accepted Solution

by:
go2guy earned 200 total points
ID: 10960439
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.
0

Featured Post

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

596 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question