sqlplus copy command

[sudheer_nm]

Could somebody forward me the details of copy command or any link?

[tombest]

See below. Note that it is a SQLPLUS command, not an SQL stmt.

http://download-east.oracle.com/docs...apb.htm#634246

[sudheer_nm]

Hi Guys,

I am planning to use sqlplus copy command to transfer data between two tables of different databases. I have around 5 Lacs record for transfer on a daily basis.

1.Is it possible to transfer this huge data thru sqlplus copy command?
2.If so do I need to change array size and how to set it. I need syntax
3.Is any performance problem bcoz I don't want to increase CPU usage.

Could any one help me out

[slimdave]

1. yes
2. "set arraysize 100" would probably do it fine
3. no, other than the usual cpu invloved in selecting from a table, and inserting into another.

[adewri]

Sudheer, try to continue on the same thread when the topic is same. Do not open new threads for the same topic.

Merging this thread with earlier ones.

[xyz2000]

SQL> help copy

COPY
----

COPY copies data from a query to a table in a local or remote
database.

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

where database has the following syntax:
username[/password]@connect_identifier


xyz

[SANJAY_G]

Avoid the COPY command as it is going to be deprecated in future release of Oracle.

[slimdave]

Originally posted by SANJAY_G
Avoid the COPY command as it is going to be deprecated in future release of Oracle.

Where does this information come from?

[shailendra]

but what is the actual drawback of Using this Copy command.

Shailendra

[TomazZ]

Originally posted by slimdave
Where does this information come from?

http://metalink.oracle.com/metalink/...&p_id=171870.1