Re: ORA-01002: fetch out of sequence

From: Tom Best <tabest_at_bellatlantic.dontspamme.net>
Date: 2000/07/30
Message-ID: <rUZg5.2158$oA6.138197@typhoon2.ba-dsg.net>#1/1

Blinky:

This doesn't really make sense to me, but it's worth a try to see if it fixes it...

In SQL*Plus, set ARRAYSIZE to 100 and COPYCOMMIT to 100.

HTH,
Tom Best

blinky <blinky_at_nospam.com> wrote in message news:so6sm2c4o0b98_at_corp.supernews.com...
> I'm often getting
> ORA-01002: fetch out of sequence
>
> issuing very simple copy from commands
>
> attempting to copy a table to the same table in a different schema
>
>
> Any ideas what can cause this ?
>
> Does it mean the indices are corrupt ?
>
> Does it mean that you cannot run copy from unless you disable
> indices of the target table ?
>
>
>
>
Received on Sun Jul 30 2000 - 00:00:00 CDT