This view contains log history information.
Column | Datatype | Description |
---|---|---|
DB_NAME |
VARCHAR2(9) |
Name of the database |
DB_ID |
NUMBER |
Database ID |
DB_CREATED |
DATE |
Creation date of the source database (corresponds to the CREATED column in the V$DATABASE view) |
TIMESTAMP |
DATE |
Date when the dictionary was created |
RESET_SCN |
NUMBER |
Reset log SCN when the dictionary was created |
RESET_SCN_TIME |
DATE |
Timestamp of the reset log SCN when the dictionary was created |
DB_VERSION_TIME |
DATE |
Version time for the source database (corresponds to the VERSION_TIME column in the V$DATABASE view) |
DB_CHARACTER_SET |
VARCHAR2(30) |
Character set of the source database |
DB_VERSION |
VARCHAR2(64) |
This column is deprecated. |
DB_STATUS |
VARCHAR2(64) |
This column is deprecated. |
DICTIONARY_SCN |
NUMBER |
Database checkpoint SCN at which the dictionary was created |
ENABLED_THREAD_MAP |
RAW(16) |
This column is deprecated. |
DB_TXN_SCN |
NUMBER |
SCN at which the dictionary was created |
FILENAME |
VARCHAR2(512) |
Dictionary file name |
INFO |
VARCHAR2(32) |
Informational/Status message
|
STATUS |
NUMBER |
A NULL indicates a valid dictionary file for the list of log files. A non-NULL value indicates further information is contained in the INFO column as a text string. |