tempfileSpec

Syntax

tempFileSpec::=

Purpose

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

Restrictions and Usage Notes

You can specify an absolute path name, or a path name relative to the Oracle home.
Double and single quotes are both legal (although only single quotes are shown in the diagram).
Use ? to represent the Oracle home and @ for the Oracle SID.

See Also:
"Placeholders" to learn about the difference between single and double quotes, as well as the behavior of environment variables in RMAN quoted strings
You can use the REPORT SCHEMA command or the V$TEMPFILE control file view to get information about the current tempfiles.

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.