Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> [Q] archive log list from tables

[Q] archive log list from tables

From: Almut Herzog <al-her_at_sectra.se>
Date: 1997/03/21
Message-ID: <333253D2.1EC5@sectra.se>#1/1

HI,

Using 'archive log list' from SQLDBA results in lines like

Database log mode            ARCHIVELOG
Automatic archival           ENABLED
Archive destination          /tmp/xxx

Oldest online log sequence 59
Next log sequence to archive 61
Current log sequence 61

How do I query 'Oldest online log sequence' and 'Current log sequence' from a table? From which table?

Please reply by e-mail, too. It's faster and more reliable. TIA

-- 
Almut Herzog
SECTRA-Imtec AB                     e-mail: al-her_at_sectra.se
Teknikringen 2                      voice:  ++46 13 235221
583 30 Linkoping                    fax:    ++46 13 212185
SWEDEN
Received on Fri Mar 21 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US