DB_KEY |
NUMBER |
NOT NULL |
The primary key for the database. Use this column to form a join with almost any other catalog view. |
DBID |
NUMBER |
NOT NULL |
Unique identifier for the database. |
DBINC_KEY |
NUMBER |
NOT NULL |
The primary key for the incarnation. |
NAME |
VARCHAR2(8) |
NOT NULL |
The DB_NAME for the database at the time of the RESETLOGS operation. |
RESETLOGS_CHANGE# |
NUMBER |
NOT NULL |
The SCN of the RESETLOGS operation that created this incarnation. |
RESETLOGS_TIME |
DATE |
NOT NULL |
The timestamp of the RESETLOGS operation that created this incarnation. |
CURRENT_INCARNATION |
VARCHAR2(3) |
|
YES if it is the current incarnation; NO if it is not. |
PARENT_DBINC_KEY |
NUMBER |
|
The DBINC_KEY of the previous incarnation for this database. The value is NULL if it is the first incarnation recorded for the database. |