I would try increasing the Buffer Size. Hopefully that would work for you!
Alex Ivascu
DBA
"Ash" <akhi9031_at_yahoo.com> wrote in message
news:7fcfcf73.0110160748.72e014a9_at_posting.google.com...
> O/S - Solaris 8
> Oracle 8.1.7
>
> -----------------------------------
> Do you have any idea how to fix it? It is a newly build database. I can
> run this same script on my old machine (8.0.5).
>
> Thanks
> -----------------------------------
>
> SQL> copy from user/pass_at_db.world replace emp using select * from emp;
>
> Array fetch/bind size is 15. (arraysize is 15)
> Will commit when done. (copycommit is 0)
> Maximum long size is 80. (long is 80)
>
> select * from emp
> *
> Error in SELECT statement: ORA-01002: fetch out of sequence
Received on Tue Oct 16 2001 - 23:09:00 CDT