Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Unable to load a string of length 356 into VARCHAR2(2000) column
Hi,
I have been trying to load several text records into a table consisting a VARCHAR2(2000) column using SQL*Loader with delimiter. Most records with short text length have no problem being loaded into the table. However, for those with longer text lengths I keep getting the following error message in the log file:
Record 1: Rejected - Error on table XXX, column YYY. Field in data file exceeds maximum length
I counted the text length of one of the rejected record which had only 356 characters. I use "=" as the column delimiter. I do not understand why VARCHAR2(2000) can not hold 356 characters. Where did I miss?
Thanks,
Simon Received on Mon Oct 18 2004 - 11:17:32 CDT
![]() |
![]() |