|
DB_KEY
|
NUMBER
|
The primary key for the target database. |
|
DBINC_KEY
|
NUMBER
|
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)
|
The DB_NAME of the database incarnation to which this record belongs. |
|
TS#
|
NUMBER
|
The number of the tablespace to which the datafile belongs. The TS# may exist multiple times in the same incarnation if the tablespace is dropped and re-created. |
|
TABLESPACE_NAME
|
VARCHAR2(30)
|
The tablespace name. The name may exist multiple times in the same incarnation if the tablespace is dropped and re-created. |
|
FILE#
|
NUMBER
|
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
|
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 size of the datafile in blocks. |
|
BLOCK_SIZE
|
NUMBER
|
The size of the data blocks in bytes. |
|
NAME
|
VARCHAR2(1024)
|
The datafile filename. |
|
STOP_CHANGE#
|
NUMBER
|
For offline or read-only datafiles, the SCN value such that no changes in the redo stream at an equal or greater SCN apply to this file. |
|
STOP_TIME
|
DATE
|
For offline normal or read-only datafiles, the time beyond which there are no changes in the redo stream that apply to this datafile. |
|
READ_ONLY
|
NUMBER
|
1 if the file is read-only; otherwise 0. |
|
RFILE#
|
NUMBER
|
The relative file number of this datafile within its tablespace. |
|
INCLUDED_IN_DATABASE_BACKUP
|
VARCHAR2(3)
|
Indicates whether this tablespace is included in whole database backups: YES or NO. The NO value occurs only if CONFIGURE EXCLUDE was run on the tablespace that owns this datafile. |
|
AUX_NAME
|
VARCHAR2(1024)
|
Indicates the auxiliary name for the datafile as set by CONFIGURE AUXNAME. |
