Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Copy from 8.0.5 to 8.1.5 problem.

Re: Copy from 8.0.5 to 8.1.5 problem.

From: Alex Ivascu <alex_at_ivascu.com>
Date: Wed, 17 Oct 2001 04:09:00 GMT
Message-ID: <wv7z7.19119$8a6.5189789@typhoon.we.rr.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US