Re: Location of redo logs

From: <abraham_at_my-dejanews.com>
Date: Fri, 23 Oct 1998 20:56:07 GMT
Message-ID: <70qqh7$4us$1@nnrp1.dejanews.com>

In article <70qdm9$1u8k1_at_tmpsp002.tmpprv.allied.com>, "Zachary Agatstein" <Zachary.Agatstein_at_atsc.allied.com> wrote:
> A newbie question:
> If I don't have a LOG_ARCHIVE_DEST parameter specified in my initxxx.ora
> file, how do I find out where these redo logs reside?
>
> Thanks
>
> Zach
>
>

select file_name from dba_data_files

and identify your redo log files

Abraham

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Oct 23 1998 - 15:56:07 CDT