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: Archive Logs

Re: Archive Logs

From: Alistair Thomson <alistair_at_despammed.com>
Date: Mon, 10 Mar 2003 09:51:48 -0000
Message-ID: <b4hn7i$guo$1$8300dec7@news.demon.co.uk>


Hi

Connect as SYS or SYSTEM and type

select * from v$logfile;

That will give you what you want.

Alistair

"Henry" <henry_at_nothing.com> wrote in message news:1047289325.842696_at_ftp.adept.co.za...
>
>
> Hi there
> Can someone help me with the sql statement for finding in which directory
> the archive logs are stored?
>
> cheers
> H
>
>
Received on Mon Mar 10 2003 - 03:51:48 CST

Original text of this message

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