| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL*Loader Problem
Bill:
I also found that I have to specify the size of the column even if the data field is being skipped using filler!
Ken
-----Original Message-----
Sent: Friday, January 11, 2002 10:55 AM
To: Multiple recipients of list ORACLE-L Subject: Re: SQL*Loader Problem
Where's what note 113211.1 on metalink says about this. I hope it helps.
Problem Description
Using SQL*Loader to load data into a database table and rows fail to load with the message:
Record X: Rejected - Error on table "XXXX"."XXXX", column "XXXXXX". Field in data file exceeds maximum length
The data to be loaded will be longer than 255 characters and the database column is set to larger than 255 characters.
Solution Description
In the control file specify the length of the column if the columns in the database are longer than 255 characters.
eg
LOAD DATA
INFILE *
INTO TABLE "TEST"."TEST1"
APPEND
FIELDS TERMINATED BY ','
("COL1", "COL2" char(4000), "COL3")
BEGINDATA
333, data data data longer than 255 characters data data etc,this will work
Explanation
As a default, if the column length is not specified, it will default to a maximum of 255 characters. If the database column is longer than 255 characters and the data to be loaded exceeds 255 characters, then it exceeds the maximum length. Specifying the maximum length in the control file overrides the default setting.
References
Oracle8 Server Utilities
Additional Search Words
sqlloader loader
.
Bill Gentry
DBA
Allina Health System
Minneapolis, MN 55403
612-775-1190
gentry_at_allina.com
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Friday, January 11, 2002 9:55 AM
> 8.1.7 on W2000
>
> I am loading data and keep getting an error. The fields are text about
400+
> characters. The column I am loading into is varchar2(4000). I keep
getting
> rejects with this error: Field in data file exceeds maximum length. Any
> ideas as to why this is happening?
>
> Thanks,
>
> Ken Janusz, CPIM
> Database Conversion Lead
> Sufficient Systems, Inc.
> Minneapolis, MN
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ken Janusz
> INET: ken.janusz_at_sufsys.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Gentry INET: gentry_at_allina.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: ken.janusz_at_sufsys.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Fri Jan 11 2002 - 12:05:51 CST
 |
 |