DB_KEY |
NUMBER |
NOT NULL |
The primary key for the target database. |
DBINC_KEY |
NUMBER |
NOT NULL |
The primary key for the incarnation of the target database. Use this column to form a join with RC_DATABASE_INCARNATION. |
DB_NAME |
VARCHAR2(8) |
NOT NULL |
The DB_NAME of the database incarnation to which this record belongs. |
TS# |
NUMBER |
NOT NULL |
The tablespace identifier in the target database. The TS# may exist multiple times in the same incarnation if the tablespace is dropped and re-created. |
TABLESPACE_NAME |
VARCHAR2(30) |
NOT NULL |
The tablespace name. The name may exist multiple times in the same incarnation if the tablespace is dropped and re-created. |
FILE# |
NUMBER |
NOT NULL |
The absolute file number of the datafile. The same datafile number may exist multiple times in the same incarnation if the datafile is dropped and re-created. |
CREATION_CHANGE# |
NUMBER |
NOT NULL |
The SCN at datafile creation. |
CREATION_TIME |
DATE |
|
The time of datafile creation. |
DROP_CHANGE# |
NUMBER |
|
The SCN recorded when the datafile was dropped. If a new datafile with the same file number is discovered then the DROP_CHANGE# is set to CREATION_CHANGE# for the datafile; otherwise the value is set to RC_CHECKPOINT.CKP_SCN. |
DROP_TIME |
DATE |
|
The time when the datafile was dropped. If a new datafile with the same file number is discovered then the DROP_TIME is set to CREATION_TIME for the datafile; otherwise the value is set to RC_CHECKPOINT.CKP_TIME. |
BYTES |
NUMBER |
|
The size of the datafile in bytes. |
BLOCKS |
NUMBER |
|
The number of blocks in the datafile. |
BLOCK_SIZE |
NUMBER |
NOT NULL |
The size of the data blocks. |
NAME |
VARCHAR2(1024) |
|
The datafile filename. |
STOP_CHANGE# |
NUMBER |
|
SCN for datafile if offline normal or read-only. |
READ_ONLY |
NUMBER |
NOT NULL |
1 if STOP_CHANGE# is read-only; otherwise 0. |