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
:= { 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.
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.
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.