SQL*PLUS Copy Command Limitation?

[Bong]

what about environment settings

sql>set array 1000
sql>
sql>set long 2000
SQL> copy from user/user@1234 to user/user@4321 create test1 using select
* from t1

Array fetch/bind size is 1000. (arraysize is 1000)
Will commit when done. (copycommit is 0)
Maximum long size is 2000. (long is 2000)

robert, i tried your suggestion still giving the same fetch out of sequence error.

Does anyone tried to execute a copy command from ORA8.0 to ORA9i? Maybe this thing dont work at all.

[pando]

Didnt you answer slimdave that you were using 9i client to 9i database? Why you say you are using Oracle 8 now...?!

[tamilselvan]

Does anyone tried to execute a copy command from ORA8.0 to ORA9i? Maybe this thing dont work at all.

The problem is most of us do not use Oracle 8.
We have migrated to 8i / 9i / 10g....
Hence, we do not have working env to test your case.
Better, you should contact Oracle Support.

Tamil

[sambavan]

Given the issues, the solution is to use DBLINKs than COPY i.m.h.o.

The problem exists all the way from 8.1.6. Looks like it is yet to be addressed by Oracle. I don't have the setup here, to do the test.

Thanx,
Sam

[jmodic]

Will having a long column give this error?

No, it shouldn't (unless it is a bug).

[Bong]

[QUOTE=sambavan]Given the issues, the solution is to use DBLINKs than COPY i.m.h.o.

I agree with you. But DBLINK is actually the reason why I wanted to use COPY command because I can not DBLINK Orac8 and Ora9i.

Any work around?

[davey23uk]

why cant you dblink?

[Bong]

why cant you dblink?

The DBLink from Oracle 8.0 to Oracle 9i is not working. Only from Oracle 8i to Oracle 9i is possible.