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

Thread: error in copying data

  1. #1
    Join Date
    May 2002
    Posts
    232
    Heloo,friends
    when i try to copy the table from one db to another,i get a error
    SQL> copy from sghdev/sghdev@sgh.192.100.86.27 to webdbdev/webdbdev@sgh.192.100.86.52 -
    > create range(x,y) -
    > using select * from prepaid_range;

    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 prepaid_range
    *
    Error in SELECT statement: ORA--1002: Message -1002 not found; product=RDBMS; facility=ORA

    THANKS
    kavitha
    kavitha

  2. #2
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268
    01002, 00000, "fetch out of sequence"
    *Cause: This error means that a fetch has been attempted from a cursor
    which is no longer valid. Note that a PL/SQL cursor loop
    implicitly does fetches, and thus may also cause this error.
    There are a number of possible causes for this error, including:
    1) Fetching from a cursor after the last row has been retrieved
    and the ORA-1403 error returned.
    2) If the cursor has been opened with the FOR UPDATE clause,
    fetching after a COMMIT has been issued will return the error.
    3) Rebinding any placeholders in the SQL statement, then issuing
    a fetch before reexecuting the statement.
    *Action: 1) Do not issue a fetch statement after the last row has been
    retrieved - there are no more rows to fetch.
    2) Do not issue a COMMIT inside a fetch loop for a cursor
    that has been opened FOR UPDATE.
    3) Reexecute the statement after rebinding, then attempt to
    fetch again.

  3. #3
    Join Date
    Feb 2001
    Posts
    5

    Exclamation

    What are the versions source & target DB ?

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