Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: archive log destination
Grace,
v$log_history will show the archive destination, the v$parameter view may only be populated when the init.ora is read in, someone else may be able to verify that.
Phil Cook
gwleung_at_pacbell.net wrote in article <33497E86.DED_at_pacbell.net>...
> I am running Oracle 7.1.6 in ARCHIVELOG mode. I tried to change the
archived log
> destination from LOG_ARCHIVE_DEST to another location by ALTER SYSTEM
ARCHIVE LOG START
> 'new_dest'; It works fine, except it still shows the original
destination when querying
> up v$parameter. Is there any view/table which will show the current
archive log
> destination?
>
> Grace Leung
>
Received on Mon Apr 07 1997 - 00:00:00 CDT