Re: sqlldr: Field in data file exceeds maximum length?
From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 22 May 2007 10:01:58 -0700
Message-ID: <1179853319.476294_at_bubbleator.drizzle.com>
Date: Tue, 22 May 2007 10:01:58 -0700
Message-ID: <1179853319.476294_at_bubbleator.drizzle.com>
Phil Lawrence wrote:
> Can anyone see why sqlldr thinks the last field in the below example
> record exceeds maximum length?
>
> I show the last field as 1001 characters, including the newline. That
> equals 1000 without the newline, and that is the fieldsize,
> CHAR(1000).
CREATE TABLE test (
testcol VARCHAR2(4000));
Load into this table ... then:
SELECT MAX(LENGTH(testcol)) FROM test;
Two thoughts. The first is that your assumption about the size is incorrect. The second is CHAR(1000)? You've got to be kidding.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Tue May 22 2007 - 19:01:58 CEST