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.
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.
Life is a journey, not a destination!
Click Here to Expand Forum to Full Width