Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Loader problems
"Colin Young" <x_at_nospam.com> wrote:
>I'm trying to import some data from a comma delimited file (actually, I
>have it in Excel, so the format can be changed) into an Oracle table using
>SQL Loader. Out of 64 rows, only 13 import correctly and the rest tell me:
>
>"Record 13: Rejected - Error on table TEMPIMPORT, column DESCRIPTION.
>Field in data file exceeded maximum specified length"
>
>The field is going into a varchar2(2000) column in the destination table,
>and at least some of the rows that give the error are definitely less than
>2000 characters.
>
>Any ideas (including alternate methods to get the data in)?
You also have to specify in the control file how much space is reserved for conversion of the data. The default is 255 bytes, so just specify CHAR(2000) in the control file of SQL*Loader.
Gerhard.
-- Dipl. Inform. Gerhard Möller -- Gerhard.Moeller_at_OFFIS.Uni-Oldenburg.DE OFFIS | | | | | | Tel.: 0441/9722-122 Escherweg 2 | | | | | | Sekr.: 0441/9722-113 oder -101 D-26121 Oldenburg |O|F|F|I|S| Fax: 0441/9722-102Received on Wed Jul 02 1997 - 00:00:00 CDT