RE: SQLLDR field in data file exceeds max. length Problem

From: Figueiredo, Pedro <PFigueiredo_at_europeantelecom.at>
Date: Tue, 12 Sep 2000 09:41:35 -0000
Message-Id: <10617.116691@fatcity.com>

Hi,

Even in conventional path, I think it's possible to load columns with = more
than 255 c.
It's necessary to supply the length we need for these "special" columns = on
sql*loader control file.

LOAD DATA
INFILE icod_faq_type_a.dat
append INTO TABLE icod_faq_type
FIELDS TERMINATED BY "|"
(faq_type_id,

 faq_title,
 faq_text_title,
 faq_text	CHAR(4000),

is_faq,
active,
seq_no )

Bye

Pedro

-----Original Message-----
From: Lucia DeMeester [mailto:ldemeester_at_nm2.com] Sent: ter=E7a-feira, 12 de Setembro de 2000 2:36 To: Multiple recipients of list ORACLE-L Subject: FW: SQLLDR field in data file exceeds max. length Problem - HELP Thanks to Janardhana, I tried again added direct=3Dy on my sqlldr = command line
and I was able to load those records which was rejected earlier.

Best Regards,
Lucia

-----Original Message-----
Sent: Monday, September 11, 2000 4:06 PM To: 'ORACLE-L_at_fatcity.com'
Cc: 'Lucia DeMeester'
HELP Lucia,

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

Janardhana Babu

-----Original Message-----
Sent: Monday, September 11, 2000 4:45 PM To: Multiple recipients of list ORACLE-L

Lister,

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.

Regards,
Lucia

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:

LOAD DATA
INFILE icod_faq_type_a.dat
append INTO TABLE icod_faq_type
FIELDS TERMINATED BY "|"
(faq_type_id,

 faq_title,
 faq_text_title,
 faq_text,

is_faq,
active,
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 1-800-662-5616 = 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 1-800-583-4922 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 1-800-662-5616. = Personalized
and custom orders are not returnable.|1|1|40

--
Author: Lucia DeMeester
  INET: ldemeester_at_nm2.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).

--=20
Author: Lucia DeMeester
  INET: ldemeester_at_nm2.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

Received on Tue Sep 12 2000 - 04:41:35 CDT

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