datafileSpec

Syntax

Text description of the illustration datafile.gif

Purpose

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

Restrictions and Usage Notes

You cannot use environment variables such as $ORACLE_HOME in filenames. You must specify the relative or absolute path name.

Keywords and Parameters

'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 /oracle/dbs/tbs_12.f to disk, specifying it by filename:

COPY DATAFILE '/oracle/dbs/tbs_12.f' TO '/oracle/copy/tbs_1.copy';

Specifying a Datafile by Absolute File Number: Example

This example copies datafile /oracle/dbs/tbs_31.f to disk, specifying it by file number:

RUN
{
  ALLOCATE CHANNEL ch1 DEVICE TYPE DISK;
  COPY DATAFILE 10 TO '/oracle/copy/tbs_31.copy';
}