Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Loader problems

Re: SQL Loader problems

From: Gerhard Moeller <Gerhard.Moeller_at_OFFIS.Uni-Oldenburg.de>
Date: 1997/07/02
Message-ID: <5pcs3l$dja@news.Informatik.Uni-Oldenburg.DE>#1/1

"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-102
Received on Wed Jul 02 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US