Re: SQL*Plus: COPY command, LONG datatype, and ORA-01008

This is interesting... The copy command is copying data as if it were doing an insert on your table. Applying intermintent commits during large data uploads may help. Although this doesn't exactly match the error you are getting.

on the remote database try
set copycommit 1 - copycommit tells SQL*Plus how many batches should be committed at one time
set arraysize 500 -- This determines the number of records that will be retrieved in each "batch". Adjust this number as necessary.

then run your coy scripts on your local database COPY TO &un/&pw_at_&cs INSERT table_1 USING SELECT * from table_1 COPY TO &un/&pw_at_&cs INSERT table_2 USING SELECT * from table_2

hope this helps

• Thomas Bartos