Re: V$ for control files

You should have access to a view called v$controlfile. Or you can use sys.V_$controlfile. Or you could use view v$parameter where name='control_files'.

oracle_at_more.net wrote in article <5clepl$413_at_news.more.net>...
> I am trying to write a universal backup script that I can run from one
 machine
> and point at multiple instances of oracle. I need to be able to query the
 location
> of all data, control, and redo log files. I have the data and redo log
 files by querying
> the v$datafile & v$logfile views but can't seem to find a view for the
 control files. The
> sgadefinstance.dbf file is another file that seems to be another file
 that I can't find in
> the database.
>
>
> Any help is appreciated, David
>
Received on Tue Jan 28 1997 - 00:00:00 CST