December 2002
Intermediate to advanced
928 pages
85h 29m
English
COPY
COPY [copyOption[copyOption]...] {copyInputfileTO { AUXNAME | 'filename' [copyOption[copyOption]...] } [,copy_inputfileTO { AUXNAME | 'filename' [copyOption[copyOption]...] } ]... | (copyInputfileTO { AUXNAME | 'filename' [copyOption[copyOption]...] } ) [(copy_inputfile TO { AUXNAME | 'filename' [copyOption[copyOption]...] } ) ]... };
Oracle9i syntax:
copyOption:= { TAG [=] [']tag_name['] | LEVEL [=]integer| NOCHECKSUM | CHECK LOGICAL |keepOption}copyInputFile:= { DATAFILEdatafileSpec| 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:= { DATAFILEdatafileSpec| 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.
Specifies that the result of the COPY command is an alternate name for a file that was previously defined through the SET command.
Prevents block checksums from being computed.
Common keywords and clauses: datafileSpec, filename, keepOption, tag_name.