[Home] [Help] [Dependency Information]
Object Name: | REDO_DB |
---|---|
Object Type: | TABLE |
Owner: | SYSTEM |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSAUX |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
REDO_DB_IDX | NORMAL | NONUNIQUE | SYSAUX |
DBID
THREAD# RESETLOGS_SCN_BAS RESETLOGS_SCN_WRP RESETLOGS_TIME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DBID | NUMBER | Yes | ||
GLOBAL_DBNAME | VARCHAR2 | (129) | ||
DBUNAME | VARCHAR2 | (32) | ||
VERSION | VARCHAR2 | (32) | ||
THREAD# | NUMBER | Yes | ||
RESETLOGS_SCN_BAS | NUMBER | Yes | ||
RESETLOGS_SCN_WRP | NUMBER | Yes | ||
RESETLOGS_TIME | NUMBER | Yes | ||
PRESETLOGS_SCN_BAS | NUMBER | |||
PRESETLOGS_SCN_WRP | NUMBER | |||
PRESETLOGS_TIME | NUMBER | |||
SEQNO_RCV_CUR | NUMBER | |||
SEQNO_RCV_LO | NUMBER | |||
SEQNO_RCV_HI | NUMBER | |||
SEQNO_DONE_CUR | NUMBER | |||
SEQNO_DONE_LO | NUMBER | |||
SEQNO_DONE_HI | NUMBER | |||
GAP_SEQNO | NUMBER | |||
GAP_RET | NUMBER | |||
GAP_DONE | NUMBER | |||
APPLY_SEQNO | NUMBER | |||
APPLY_DONE | NUMBER | |||
PURGE_DONE | NUMBER | |||
HAS_CHILD | NUMBER | |||
ERROR1 | NUMBER | |||
STATUS | NUMBER | |||
CREATE_DATE | DATE | |||
TS1 | NUMBER | |||
TS2 | NUMBER | |||
GAP_NEXT_SCN | NUMBER | |||
GAP_NEXT_TIME | NUMBER | |||
CURSCN_TIME | NUMBER | |||
RESETLOGS_SCN | NUMBER | |||
PRESETLOGS_SCN | NUMBER | |||
GAP_RET2 | NUMBER | |||
CURLOG | NUMBER | |||
ENDIAN | NUMBER | |||
ENQIDX | NUMBER | |||
SPARE4 | NUMBER | |||
SPARE5 | DATE | |||
SPARE6 | VARCHAR2 | (65) | ||
SPARE7 | VARCHAR2 | (129) | ||
TS3 | NUMBER | |||
CURBLKNO | NUMBER | |||
SPARE8 | NUMBER | |||
SPARE9 | NUMBER | |||
SPARE10 | NUMBER | |||
SPARE11 | NUMBER | |||
SPARE12 | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT DBID
, GLOBAL_DBNAME
, DBUNAME
, VERSION
, THREAD#
, RESETLOGS_SCN_BAS
, RESETLOGS_SCN_WRP
, RESETLOGS_TIME
, PRESETLOGS_SCN_BAS
, PRESETLOGS_SCN_WRP
, PRESETLOGS_TIME
, SEQNO_RCV_CUR
, SEQNO_RCV_LO
, SEQNO_RCV_HI
, SEQNO_DONE_CUR
, SEQNO_DONE_LO
, SEQNO_DONE_HI
, GAP_SEQNO
, GAP_RET
, GAP_DONE
, APPLY_SEQNO
, APPLY_DONE
, PURGE_DONE
, HAS_CHILD
, ERROR1
, STATUS
, CREATE_DATE
, TS1
, TS2
, GAP_NEXT_SCN
, GAP_NEXT_TIME
, CURSCN_TIME
, RESETLOGS_SCN
, PRESETLOGS_SCN
, GAP_RET2
, CURLOG
, ENDIAN
, ENQIDX
, SPARE4
, SPARE5
, SPARE6
, SPARE7
, TS3
, CURBLKNO
, SPARE8
, SPARE9
, SPARE10
, SPARE11
, SPARE12
FROM SYSTEM.REDO_DB;
SYSTEM.REDO_DB does not reference any database object
SYSTEM.REDO_DB is referenced by following:
|
|
|