Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Archive Logs
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