Solved

location dbf files

Posted on 2004-04-30
6
1,857 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
6 Comments
 
LVL 12

Expert Comment

by:catchmeifuwant
Comment Utility
????
0
 
LVL 22

Expert Comment

by:Helena Marková
Comment Utility
It seems to be Visual Foxpro ...
0
 
LVL 13

Expert Comment

by:anand_2000v
Comment Utility
The locations are specified during database creation by the DBA.       
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

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

Author Comment

by:plennon
Comment Utility
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 50 total points
Comment Utility
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Via a live example, show how to take different types of Oracle backups using RMAN.

743 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now