Thanks Rick
Worked well thanks!
"Rick Anderson" <Richard.Anderson_at_oracle.com> wrote in message
news:Xns933A4EEFC6598RichardAndersonoracl_at_148.87.1.53...
> "Telemachus" <telemachus_at_ulysseswillreturn.net> wrote in
> news:V8%aa.1512$pK2.2235_at_news.indigo.ie:
>
> > Absolutely silly question...
> >
> > Is archiving switched on ?
> >
> > because on my play instance where archiving is not enabled when I do
> >
> > show parameter log_archive_dest I get no answer either ...
> >
> >
> > "Henry" <henry_at_nothing.com> wrote in message
> > news:1047296025.106957_at_ftp.adept.co.za...
> >> I'm returned not path when I perform
> >> SELECT * FROM v$parameter
> >> WHERE NAME LIKE 'log_archive_dest%'; I want to get where the archive
> >> logs will reside.
> >> What have I done wrong?
> >>
> >> I'm using windows and runing 9i.
> >>
> >> Cheers
> >>
> >
> >
> >
>
> Do NOT use V$PARAMETER - use V$ARCHIVE_DEST.
> For example:
>
> select dest_id,status,destination from v$archive_dest;
>
> Hope this helps.
> Rick
Received on Mon Mar 10 2003 - 07:42:30 CST
