SQLPlus Copy

COPY Command Syntax:

COPY {FROM database TO database} {APPEND|CREATE|INSERT|REPLACE}
destination_table [(column, column, column, …)] USING query

database = username[/password]@database_name

COPY Command Examples:

COPY FROM scott/password@dba_1 TO mike/password@dba_2
REPLACE dba_2.customers
USING SELECT * FROM dba_1.customers

COPY FROM scott/password@dba_1
CREATE new_products (product_id, product_name, price)
USING SELECT product_id, description, price FROM products
WHERE product_status=’NEW’;