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

Hello Mark,

Yes you can. Just have a look at v$controlfile_record_section where type = 'DATAFILE'or 'LOG HISTORY' , for some of the needed values (RECORDS_TOTAL column gives right figures).

rgrds,

mark a écrit :

> 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 Mon Mar 26 2001 - 19:13:21 CST