Re: sqlldr: Field in data file exceeds maximum length?
From: Phil Lawrence <prlawrence_at_gmail.com>
Date: 22 May 2007 14:40:18 -0700
Message-ID: <1179870018.220305.293480_at_u30g2000hsc.googlegroups.com>
Date: 22 May 2007 14:40:18 -0700
Message-ID: <1179870018.220305.293480_at_u30g2000hsc.googlegroups.com>
I found the answer at:
http://www.orafaq.com/forum/t/50219/0/
The problem occurs because the default size for sqlldr is char(255). Find the column(s) you suspect might be very large and specify in the ctl file
COL1 CHAR(500) NULLIF COL1=BLANKS,
COL2 CHAR(500) NULLIF COL2=BLANKS,
where COL1 and COL2 are the columns that are wider than the default
255 xters.
Received on Tue May 22 2007 - 23:40:18 CEST