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
[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).
--
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).
