|
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.
|
