Name
COPY
Synopsis
The COPY command uses SQL*Plus as a conduit for transferring data between two Oracle databases.
Warning
COPY is not being enhanced to handle datatypes and features introduced with or after Oracle8i Database. COPY is a deprecated command and may be removed in a future release of SQL*Plus.
Syntax
COPY [FROMconnection
] [TOconnection
] {APPEND | CREATE | INSERT | REPLACE}destination_table
[(column_list
)] USINGselect_statement
Parameters
- [FROM connection] [TO connection]
Specifies the source and target databases for the copy. The database to which you are connected is the default in both cases and will be used as both source and destination unless you specify otherwise.
- connection
Is the login information to use when connecting to the other database. This must be in the typical username/password@connect_string format.
- APP[END]
Causes SQL*Plus to insert the copied rows into the destination table, creating it first if necessary.
- CRE[ATE]
Causes SQL*Plus to copy the data only if the destination table is a new table. If the destination table exists, the COPY command will abort.
- INSERT
Causes SQL*Plus to insert the copied rows into the destination table only if it exists. If the destination table is a new table, the COPY command will abort.
- REP[LACE]
Causes SQL*Plus to drop the destination table if it currently exists. A new table is created, and the data are copied.
- destination_table
Is the name of the table to which you want to copy the data.
- column_list
Specifies column names to use when ...
Get Oracle SQL*Plus: The Definitive Guide, 2nd Edition 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.