tempFileSpec::=
A subclause that specifies a tempfile by name or absolute file number.
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 stringsYou can use the REPORT SCHEMA
command or the V$TEMPFILE
control file view to get information about the current tempfiles.
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:
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.