This view lists information about all datafiles registered in the recovery catalog. It corresponds to the V$DATAFILE
view. A datafile is shown as dropped if its tablespace was dropped.
Column | Datatype | Description |
---|---|---|
DB_KEY |
NUMBER |
The primary key for this database in the recovery catalog. Use this column to form a join with almost any other catalog view. |
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 . |