datafileSpec

Syntax

Text description of the illustration datafileSpec.gif

Purpose

A subclause that specifies a datafile by filename or absolute file number.

Restrictions and Usage Notes

• You can specify the relative or absolute path name.
• Double and single quotes are both legal (although only single quotes are shown in the diagram). Double quotes are recommended in the SQL command.
• 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

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 port-specific manner by the target database.
integer	Specifies the datafile by using its absolute file number. Obtain the file number from the V$DATAFILE, V$DATAFILE_COPY, or V$DATAFILE_HEADER views or REPORT SCHEMA command output.

Examples

Specifying a Datafile by Filename: Example

This example copies datafile ?/oradata/trgt/users01.dbf to disk, specifying it by filename:

COPY DATAFILE '?/oradata/trgt/users01.dbf' TO '?/oradata/users01.cpy';

Specifying a Datafile by Absolute File Number: Example

This example copies datafiles 3 and 4 to disk, specifying them by file number:

COPY DATAFILE 3 TO '?/oradata/df3.cpy',
     DATAFILE 4 TO '?/oradata/df4.cpy';