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.