Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    12

    Angry Unanswered: Urgent onunload error

    Hi there

    I am traying to copy a big table between instances, I am using onunload and then onload

    I used with other tables and it work ok.

    but now I am getting
    Error writing to tape device, Error No. = 22.

    I am typing:
    onunload -t /vol55-s/ev/etl/blj/blj_search.p -b 4 -s 1000000000000 b_blj:johnd.search

    Can some body tell me where to look for this error or what is wromg ?

    Thanks
    GB

  2. #2
    Join Date
    Jun 2004
    Posts
    7

    Red face Re: Urgent onunload error

    Hi.

    I don´t know about this error message, but I know what you can do instead of use the onunload and the onload commands.

    Use the
    "unload to <filename> select * from <tablename>"
    and the
    "load from <filename> insert into <tablename>" in the other instance to load your table.
    You must give the entire path for the file where you have unloaded the data, or be in the directory where you save it and give just the filename.

    I hope it can help you.

    Fernanda.

  3. #3
    Join Date
    Apr 2004
    Posts
    12
    Thanks Fernanda I will try that

    GB

Posting Permissions

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