DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: ORA-01002

  1. #1
    Join Date
    Jul 2000
    Posts
    147
    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

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    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];

  3. #3
    Join Date
    Jul 2000
    Posts
    147
    pipo,

    I don't have any access to metalink. Do I have to apply any patches to fix this problem?

    Thanks

  4. #4
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    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 ...

  5. #5
    Join Date
    Jul 2000
    Posts
    147
    Thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width