[Home] [Help] [Dependency Information]
Object Name: | REDO_LOG |
---|---|
Object Type: | TABLE |
Owner: | SYSTEM |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSAUX |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
REDO_LOG_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 | |||
SEQUENCE# | NUMBER | Yes | ||
DUPID | NUMBER | |||
STATUS1 | NUMBER | |||
STATUS2 | NUMBER | |||
CREATE_TIME | VARCHAR2 | (32) | ||
CLOSE_TIME | VARCHAR2 | (32) | ||
DONE_TIME | VARCHAR2 | (32) | ||
FIRST_SCN_BAS | NUMBER | |||
FIRST_SCN_WRP | NUMBER | |||
FIRST_TIME | NUMBER | |||
NEXT_SCN_BAS | NUMBER | |||
NEXT_SCN_WRP | NUMBER | |||
NEXT_TIME | NUMBER | |||
FIRST_SCN | NUMBER | |||
NEXT_SCN | NUMBER | |||
RESETLOGS_SCN | NUMBER | |||
BLOCKS | NUMBER | |||
BLOCK_SIZE | NUMBER | |||
OLD_BLOCKS | NUMBER | |||
CREATE_DATE | DATE | |||
ERROR1 | NUMBER | |||
ERROR2 | NUMBER | |||
FILENAME | VARCHAR2 | (513) | ||
TS1 | NUMBER | |||
TS2 | NUMBER | |||
ENDIAN | NUMBER | |||
SPARE2 | NUMBER | |||
SPARE3 | NUMBER | |||
SPARE4 | NUMBER | |||
SPARE5 | DATE | |||
SPARE6 | VARCHAR2 | (65) | ||
SPARE7 | VARCHAR2 | (129) | ||
TS3 | NUMBER | |||
PRESETLOGS_SCN | NUMBER | |||
SPARE8 | NUMBER | |||
SPARE9 | NUMBER | |||
SPARE10 | NUMBER | |||
OLD_STATUS1 | NUMBER | |||
OLD_STATUS2 | NUMBER | |||
OLD_FILENAME | VARCHAR2 | (513) |
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
, SEQUENCE#
, DUPID
, STATUS1
, STATUS2
, CREATE_TIME
, CLOSE_TIME
, DONE_TIME
, FIRST_SCN_BAS
, FIRST_SCN_WRP
, FIRST_TIME
, NEXT_SCN_BAS
, NEXT_SCN_WRP
, NEXT_TIME
, FIRST_SCN
, NEXT_SCN
, RESETLOGS_SCN
, BLOCKS
, BLOCK_SIZE
, OLD_BLOCKS
, CREATE_DATE
, ERROR1
, ERROR2
, FILENAME
, TS1
, TS2
, ENDIAN
, SPARE2
, SPARE3
, SPARE4
, SPARE5
, SPARE6
, SPARE7
, TS3
, PRESETLOGS_SCN
, SPARE8
, SPARE9
, SPARE10
, OLD_STATUS1
, OLD_STATUS2
, OLD_FILENAME
FROM SYSTEM.REDO_LOG;
SYSTEM.REDO_LOG does not reference any database object
SYSTEM.REDO_LOG is referenced by following:
|
|
|