Lagre file fo SQL*Loader
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Lagre file fo SQL*Loader

  1. #1
    Join Date
    Mar 2000
    Location
    Atlanta, GA,USA
    Posts
    155
    Hi guys!

    I got over 2Gb size file to load. I got "SQL*Loader 500: Unable to open file" and "HP-UX Error: 72: Value too large to be stored to data type" error messages.
    I have HP-UX 10.20 with large file option for this particular filesystem and Oracle 7.2

    Any idea?

    Sergey.

  2. #2
    Join Date
    Apr 2000
    Posts
    126

    Wink Lagre file fo SQL*Loader

    I searched metalink and found your error. Oracle instructed the person to contact HP support.

  3. #3
    Join Date
    Mar 2000
    Location
    Atlanta, GA,USA
    Posts
    155
    HP support said it's Oracle bug and should be patch #612534 but I failed to find the patch on metalink.

    Sergey.

  4. #4
    Join Date
    Apr 2000
    Posts
    126

    Wink Lagre file fo SQL*Loader

    A patch for 7.2 probably isn't on metalink. The analyst will probably have to place it there or send it to you.

  5. #5
    Join Date
    Mar 2000
    Location
    Atlanta, GA,USA
    Posts
    155
    Okay.
    Thanks,

    Sergey.

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