RC_TEMPFILE

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