DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.CDB_REDO_LOG

Object Details
Object Name: CDB_REDO_LOG
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
DBID NUMBER
Yes
GLOBAL_DBNAME VARCHAR2 (129)
DBUNAME VARCHAR2 (32)
VERSION VARCHAR2 (32)
THREAD# NUMBER
Yes
RESETLOGS_SCN NUMBER

RESETLOGS_TIME NUMBER
Yes
PRESETLOGS_SCN NUMBER

PRESETLOGS_TIME NUMBER

SEQUENCE# NUMBER
Yes
DUPID NUMBER

LOG_TYPE NUMBER

LOG_STATE NUMBER

CREATE_TIME VARCHAR2 (32)
CLOSE_TIME VARCHAR2 (32)
DONE_TIME VARCHAR2 (32)
FIRST_SCN NUMBER

FIRST_TIME NUMBER

NEXT_SCN NUMBER

NEXT_TIME NUMBER

BLOCKS NUMBER

BLOCK_SIZE NUMBER

CREATE_DATE DATE

ERROR1 NUMBER

ERROR2 NUMBER

FILENAME VARCHAR2 (513)
TS1 NUMBER

TS2 NUMBER

TS3 NUMBER

ENDIAN NUMBER

OLD_BLOCKS NUMBER

OLD_LOG_TYPE NUMBER

OLD_LOG_STATE NUMBER

OLD_FILENAME VARCHAR2 (513)
CON_ID NUMBER

container id
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DBID
,      GLOBAL_DBNAME
,      DBUNAME
,      VERSION
,      THREAD#
,      RESETLOGS_SCN
,      RESETLOGS_TIME
,      PRESETLOGS_SCN
,      PRESETLOGS_TIME
,      SEQUENCE#
,      DUPID
,      LOG_TYPE
,      LOG_STATE
,      CREATE_TIME
,      CLOSE_TIME
,      DONE_TIME
,      FIRST_SCN
,      FIRST_TIME
,      NEXT_SCN
,      NEXT_TIME
,      BLOCKS
,      BLOCK_SIZE
,      CREATE_DATE
,      ERROR1
,      ERROR2
,      FILENAME
,      TS1
,      TS2
,      TS3
,      ENDIAN
,      OLD_BLOCKS
,      OLD_LOG_TYPE
,      OLD_LOG_STATE
,      OLD_FILENAME
,      CON_ID
FROM SYS.CDB_REDO_LOG;

Dependencies

[top of page]

SYS.CDB_REDO_LOG does not reference any database object

SYS.CDB_REDO_LOG is referenced by following:

SchemaPUBLIC
SynonymCDB_REDO_LOG