This view lists information about all tempfiles registered in the recovery catalog. It corresponds to the V$TEMPFILE
view. A tempfile is shown as dropped if its tablespace is dropped.
Column | Datatype | Description |
---|---|---|
DB_KEY |
NUMBER |
The primary key for the target database. 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 tablespace ID 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) |
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 tempfile. The same tempfile number may exist in the same incarnation of the tempfile is dropped and re-created. |
CREATION_CHANGE# |
NUMBER |
The SCN when the tempfile is created. |
CREATION_TIME |
DATE |
The time when the tempfile is created. |
DROP_CHANGE# |
NUMBER |
The SCN recorded when the tempfile was dropped. If a new tempfile with the same FILE# is discovered then the DROP_CHANGE# is set to CREATION_CHANGE# for the tempfile; otherwise, the value is set to RC_CHECKPOINT .CKP_SCN . |
DROP_TIME |
DATE |
The time when the tempfile was dropped. If a new tempfile with the same FILE# is discovered, then the DROP_TIME is set to CREATION_TIME for the tempfile; otherwise the value is RC_CHECKPOINT .CKP_TIME . |
BYTES |
NUMBER |
The size of the tempfile in bytes. |
BLOCK_SIZE |
NUMBER |
The block size of the tempfile in bytes. |
NAME |
VARCHAR2(1024) |
The tempfile name. |
RFILE# |
NUMBER |
The relative file number of this tempfile within the tablespace. |
AUTOEXTEND |
VARCHAR2(3) |
ON if the tempfile is autoextensible. Otherwise OFF . |
MAXSIZE |
NUMBER |
Maximum file size in blocks to which the file can be extended. Valid only when AUTOEXTEND is ON . Always 0 when AUTOEXTEND is OFF . |
NEXTSIZE |
NUMBER |
Amount of incremental size for file extensible in blocks. Valid only when AUTOEXTEND is ON . Always 0 when AUTOEXTEND is OFF . |