Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Question: Control file information kept in v$ tables?

Re: Question: Control file information kept in v$ tables?

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Tue, 27 Mar 2001 10:42:55 +0100
Message-ID: <985686227.1322.0.nnrp-09.c30bdde2@news.demon.co.uk>

You can build a file like that by querying v$datafile, v$controlfile and v$logfile and outputting appropriately.

"mark" <markw_at_crossworlds.com> wrote in message news:7sPv6.17346$FS3.208423_at_sjc-read.news.verio.net...
> Is the Controlfile information kept somewhere in the v$ tables?
>
> Can I query the database somehow and generate the same output as doing a
> backup control file to trace?
>
>
>
> Thanks for any help.
>
>
> Mark Wagner
>
>
Received on Tue Mar 27 2001 - 03:42:55 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US