Oracle in a Nutshell

Name

COPY

Synopsis

COPY [copyOption [copyOption]...]
{ copyInputfile 
TO 
  { AUXNAME | 'filename' [copyOption [copyOption]...] }
  [, copy_inputfile TO 
   { AUXNAME | 'filename' [copyOption [copyOption]...] }
  ]... 
| (copyInputfile TO
   { AUXNAME | 'filename' [copyOption [copyOption]...] }
  ) 
  [(copy_inputfile TO
    { AUXNAME | 'filename' [copyOption [copyOption]...] }
   )
  ]...
};

Oracle9i syntax:

                        copyOption :=
{ TAG [=] [']tag_name[']
| LEVEL [=] integer
| NOCHECKSUM
| CHECK LOGICAL
| keepOption
}

copyInputFile :=
{ DATAFILE datafileSpec
| DATAFILECOPY 
  { 'filename' | TAG [=] [']tag_name['] }
| ARCHIVELOG 'filename'
| CURRENT CONTROLFILE [FOR STANDBY]
| CONTROLFILECOPY 
  { 'filename' | TAG [=] [']tag_name['] }
}

Oracle8i syntax:

                        copyOption :=
{ TAG [=] [']tag_name[']
| LEVEL [=] integer
| NOCHECKSUM
| CHECK LOGICAL
}

copyInputFile :=
{ DATAFILE datafileSpec
| DATAFILECOPY 
  { 'filename' | TAG [=] [']tag_name['] }
| ARCHIVELOG 'filename'
| CURRENT CONTROLFILE
| CONTROLFILECOPY 
  { 'filename' | TAG [=] [']tag_name['] }
}

Creates image file copies of database files. For Oracle8i, you must execute this command from within the RUN command.

Keywords

AUXNAME

Specifies that the result of the COPY command is an alternate name for a file that was previously defined through the SET command.

NO CHECKSUM

Prevents block checksums from being computed.

Common keywords and clauses: datafileSpec, filename, keepOption, tag_name.