Re: ORA-01002: fetch out of sequence

Do the TNS aliases refer to databases of the same version? There is a known bug # 903258 going from 8.1.5 to 8.0.5 whose workaround is to use a insert as select instead of a copy..

insert into as select from table_at_xxx

I think you've found a bug.. I would report it.. It also helps if you post the actual code snippet and as much information as possible to begin with.. where do these TNS aliases point? (same database, different databases, over a gateway etc.,)

• Dc.

On Mon, 31 Jul 2000 12:53:03 -0400, "blinky" <blinky_at_nospam.com> wrote:

>
>"Tom Best" <tabest_at_bellatlantic.dontspamme.net> wrote in message
>news:rUZg5.2158$oA6.138197_at_typhoon2.ba-dsg.net...
>> 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.
>>
>
>I tried it, but no luck...
>Why did you suggest that ?
>
>****
> Here is the copy from command I'm using
> (with schema, tns, and table name changed)
>I do this in a standalone, just run sql*plus window...
>****
>truncate table mytable
>set arraysize 100
>set copycommit 100
>copy from myschema_at_mytns to myschema2_at_mytns insert mytable
> using select * from mytable
>
>Error in SELECT statement: ORA-01002: fetch out of sequence
>
>
>***
>
>
Received on Fri Aug 04 2000 - 00:00:00 CDT