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


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.


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

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:

SWITCH TEMPFILE 1 TO /newdisk/tmp1.f;

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