Skip Headers
Oracle® Database Backup and Recovery Reference
10g Release 2 (10.2)

Part Number B14194-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

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