Home » SQL & PL/SQL » SQL & PL/SQL » .dat,.ctrl,log files path
.dat,.ctrl,log files path [message #194220] Thu, 21 September 2006 04:04 Go to next message
prakashrao.k
Messages: 13
Registered: September 2006
Location: BANGALORE
Junior Member

can we find out the .dat fils and control files and log files path from sql prompt or any files have that this path ...

Please let me know how we can get this informatiom

Many Thanks

Prakash Rao
Re: .dat,.ctrl,log files path [message #194224 is a reply to message #194220] Thu, 21 September 2006 04:17 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Yes.

DBF Datafiles and Temp files:
select file_name, tablespace_name from dba_data_files
union all
select file_name, tablespace_name from dba_temp_files;


Database Controlfiles
select * from v$controlfile;
or
select value from v$parameter where name = 'control_files';


Redo Logs
select * from v$logfile;


Dump File Destinations
select name,value from v$parameter where name like '%dump_dest';


Archive Log Destinations
select name,value 
from   v$parameter 
where  (name like 'log_archive_dest%' 
        or name = 'log_archive_duplex_dest')
and value is not null
and description not like '%state%'
;
Re: .dat,.ctrl,log files path [message #194319 is a reply to message #194224] Thu, 21 September 2006 08:36 Go to previous message
prakashrao.k
Messages: 13
Registered: September 2006
Location: BANGALORE
Junior Member

many thnx
Previous Topic: The procedure execute very slow,how to change it!
Next Topic: email alert after export
Goto Forum:
  


Current Time: Sun Dec 04 06:14:45 CST 2016

Total time taken to generate the page: 0.15732 seconds