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/[email protected]_1 TO mike/[email protected]_2
REPLACE dba_2.customers
USING SELECT * FROM dba_1.customers
COPY FROM scott/[email protected]_1
CREATE new_products (product_id, product_name, price)
USING SELECT product_id, description, price FROM products
WHERE product_status=’NEW’;