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 [EMAIL PROTECTED] ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).