SQLLDR: Strange problem [message #70594] |
Thu, 04 July 2002 03:44 |
Andrew
Messages: 144 Registered: March 1999
|
Senior Member |
|
|
I'm trying to load some data using sqlldr,
I get the following errors in the log-file
Record 1: Rejected - Error on table TRACKER, column COMPLETE_ENTRY.
Field in data file exceeds maximum length
Record 2: Rejected - Error on table TRACKER, column COMPLETE_ENTRY.
and so on...
the column data type is varchar2(4000) (IIRC< this Is the max size for a varchar2) and I know that the entries into this column are less than 4000..
Also I can manually add the data using an insert statement, which leads me to wonder why Sqlldr thinks the data is too long for the field...
Anyone got any suggesttions?
the dataload is, at present, 1900 fields, but once the system goes into full dev, it will be closer to 190,000 entries...
Thanks...
a
|
|
|
|
|
Re: SQLLDR: Strange problem [message #71621 is a reply to message #70594] |
Wed, 04 December 2002 17:07 |
RS
Messages: 5 Registered: August 2000
|
Junior Member |
|
|
Hi,
Here, you have to implicitly specify the maximum length of a field in the control file.
The default SQLLDR will take only 255 characters max.
Eg.
The length of Input (field2) between 500-1000 chars.
In the control file:
load data into
(
field1 char TERMINATED BY "," ENCLOSED BY "~",
field2 char (1000) TERMINATED BY "," ENCLOSED BY "~"
)
If you specify the max. length, the SQLLDR will assign the space to import into the field.
Today only I saw your request.
Good luck.
RS
|
|
|