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

tempfileSpec

Syntax

tempFileSpec::=

Description of tempfilespec.gif follows
Description of the illustration tempfilespec.gif

Purpose

A subclause that specifies a tempfile by name or absolute file number.

Restrictions and Usage Notes

Keywords and Parameters

Syntax Element Description
'filename' Specifies the datafile by using either the full path or a relative filename. If you specify a relative filename, the filename is qualified in a platform-specific manner by the target database.
integer Specifies the datafile by absolute file number. Obtain the file number from the V$TEMPFILE view or REPORT SCHEMA.

Examples

Specifying a Tempfile by Filename: Example This example renames tempfile ?/oradata/trgt/tmp1.f to /newdisk/tmp1.f, specifying it by filename:

RUN {
SWITCH TEMPFILE ?/oradata/trgt/tmp1.f TO /newdisk/tmp1.f;
}

Note that the database must not be open when performing this example.

Specifying a Tempfile by Absolute File Number: Example This example renames tempfile 1 to /newdisk/tmp1.f, specifying it by absolute file number:

RUN {
SWITCH TEMPFILE 1 TO /newdisk/tmp1.f;
}

Note that the database must not be open when performing this example.