-
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@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
-
it's a known problem between 8.0.x and 8.1.x ... (bug 903258 on metalink for info)
the workaround is to use a DB*Link :
create database link [name] connect to [user] identified by [password] using '[connect string]';
insert into emp select * from emp@[DB*Link];
-
pipo,
I don't have any access to metalink. Do I have to apply any patches to fix this problem?
Thanks
-
well, I don't think so, at least no patch is given on Metalink (but you know Oracle do only release a patch if the version still is supported, which is not the case for most - if not all- 8.0 versions) ...
you can upgrade to 8.0.6.1 (in this version, bug is resolved), you can also try to do the job in the other way, by using the 'copy to' instead of the 'copy from', it might work ...
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|