|
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote