sqlldr-Is there a limit on string length on varchar2 column being loaded?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: sqlldr-Is there a limit on string length on varchar2 column being loaded?

  1. #1
    Join Date
    Oct 2000
    Posts
    76
    Hi, I am trying to load a text file (pipe delimited) into a table. There is one string that is supposed to get loaded to a varchar2(1500) column, but even the actual length of the string is definitely less than 500, the row gets rejected to bad file with error message

    Record 1: Rejected - Error on table LOADITEMS, column MFG_LONG_PROD_DESCRIPT.
    Field in data file exceeds maximum length

    Do you know if there is a limit on the character length by sqlldr?

    I am on Solaris 7 platform with oracle 8.1.6.

    J.T.

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Yes when you don't specify the text field size the loader would assume 255 characters. So in your ctl script, add char(your_varchar_size) and then loder would be happy to load this number of characters for you.

    Good luck,
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Oct 2000
    Posts
    76
    Thanks alot! It worked!
    J.T.

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