Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> FW: SQLLDR field in data file exceeds max. length Problem - HELP

FW: SQLLDR field in data file exceeds max. length Problem - HELP

From: Lucia DeMeester <>
Date: Mon, 11 Sep 2000 16:25:05 -0700
Message-Id: <>

Thanks to Janardhana, I tried again added direct=y on my sqlldr command line and I was able to load those records which was rejected earlier.

Best Regards,

-----Original Message-----
From: Janardhana Babu [] Sent: Monday, September 11, 2000 4:06 PM To: ''
Cc: 'Lucia DeMeester'
Subject: RE: SQLLDR field in data file exceeds max. length Problem - HELP Lucia,

In conventional path, there is a restriction for RSZ to 255. If you use direct path loading(direct=true), the problem would be fixed.

-----Original Message-----
From: Lucia DeMeester [] Sent: Monday, September 11, 2000 4:45 PM To: Multiple recipients of list ORACLE-L Subject: SQLLDR field in data file exceeds max. length Problem - HELP


I have a column which was set up to varchar2(4000). Somehow the loader rejects some of the records indicating Record xx: Rejected - Error on table ICOD_FAQ_TYPE, column FAQ_TEXT.
Field in data file exceeds maximum length. However, if I checked the .bad file and counted the column, it is not over 4000 characters. Is that because some of the special character cause the record rejection? Has anyone had these problems?

Thanks in advance.


desc icod.icod_faq_type;

 Name                                      Null?    Type
 ----------------------------------------- -------- ------------------------
 FAQ_TYPE_ID                               NOT NULL VARCHAR2(4)
 FAQ_TITLE                                 NOT NULL VARCHAR2(100)
 FAQ_TEXT_TITLE                                     VARCHAR2(100)
 FAQ_TEXT                                           VARCHAR2(4000)
 IS_FAQ                                             NUMBER(3)
 ACTIVE                                             NUMBER(3)
 SEQ_NO                                    NOT NULL NUMBER(3)

Here is my control file:

INFILE icod_faq_type_a.dat
append INTO TABLE icod_faq_type


 seq_no )

Rejected .bad file:
FRBY|Gift Orders|Gift Orders|Your gift messsage can be included at no additional charge. Simply let us know and we'll print it on the packing slip. For just \$4 each, we'll send your gifts in our festive paper finished with ribbon. Gift wrap is not available for some large items, furniture and items shipped directly from the supplier.|1|0|91 tele|Phone Orders|Phone Orders|Our toll-free line <B>1-800-662-5616</B> is open 24 hours a day, except Christmas and New Years Day. To help speed your ordering, please have your credit card ready and have the completed order form handy. We will gladly confirm availability and advise you of delivery dates. You will not be charged until you order is shipped.|1|1|70 info|Fax & Mail Orders|Fax & Mail Orders|Orders may be faxed to our toll-free number <B>1-800-583-4922</B> 24 hours a day. Please complete the order form in our most recent catalog and include your credit card information and your daytime phone number. If a transmission problem occurs, please mark the second fax as "Possible Duplicate-Transmission Problem".^M ^M To place mail orders, complete the order form in our most recent catalog and send it in the attached self-addressed envelope.|1|1|102 retn|Returns & Exchanges|Returns & Exchanges|If you are not completely satisfied, just return your purchase to us for an exchange or refund. Simply follow the instructions on the packing slip enclosed in your order or call our Customer Service Department at <B>1-800-662-5616</B>. <B>Personalized and custom orders are not returnable.</B>|1|1|40

Author: Lucia DeMeester

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: (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
Received on Mon Sep 11 2000 - 18:25:05 CDT

Original text of this message