Re: Help!! SQL*Loader and LONG datatype - Urgent!

The following line in the control file should do it:

long_column_name char(50000)

This tells sqlldr to load up to 50000 bytes into the column. I think it can handle up to the max size for a long. If the data you exported has line breaks in it, this may be causing you problems as sqllldr sees them as an end of record marker.

Gene Hubert
http://www.skillspoint.com -
The trusted skills advisor to the Global 2000

On Fri, 21 Jul 2000 05:27:18 GMT, Alethea <stanggirl_at_my-deja.com> wrote:

>I'm running Oracle 8.0.5. on NT. I'm using SQL*Loader to load data into
>existing tables. I've exported MS Access fields of the Memo datatype
>into .dat files for loading. These are fairly large fields and in the
>Oracle database, they are going into columns that are of the LONG
>datatype. I'm not sure what datatype to specify in the control file.
>I've tried using CHAR, INTEGER EXTERNAL, and RAW, but with no success.
>In the log, I get the following error for each row:
>
>ORA-01401: inserted value too large for column
>
>I tried changing the bindsize array, but I get this error on the
>command line:
>
>specified value for readsize (65535) less than bindsize (1000000)
>
>I'd appreciate any help!!
>
>Thank you,
>Alethea
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Fri Jul 21 2000 - 00:00:00 CDT