Re: where is archive_name in 8.x ?

From: Glen A. Stromquist <glenstr_at_my-deja.com>
Date: Wed, 20 Dec 2000 18:28:40 GMT
Message-ID: <91qtoe$dpq$1@nnrp1.deja.com>

In article <3A3D16CB.F9F17046_at_oracle.com>, Rick Anderson <Richard.Anderson_at_oracle.com> wrote:
> This is a multi-part message in MIME format.
> --------------8011E062468B172B302D9E2E
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> The V$LOG_HISTORY view never contained the name of the archivelog
resulting
> from a log switch.
> Use the V$ARCHIVED_LOG view instead, which *does* contain the
archivelog
> filename (for local destinations).

But it did have the name in pre 8 versions, see below:

SQL> desc v$log_history

 Name                            Null?    Type
 ------------------------------- -------- ----
 THREAD#                                  NUMBER
 SEQUENCE#                                NUMBER
 TIME                                     VARCHAR2(20)
 LOW_CHANGE#                              NUMBER
 HIGH_CHANGE#                             NUMBER
 ARCHIVE_NAME                             VARCHAR2(257)

I'll just have to modify my script to use v$archived_log, it may even make it simpler.

Thanks!

Sent via Deja.com
http://www.deja.com/ Received on Wed Dec 20 2000 - 12:28:40 CST