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

Home -> Community -> Usenet -> c.d.o.server -> Help!! SQL*Loader and LONG datatype - Urgent!

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

From: Alethea <stanggirl_at_my-deja.com>
Date: 2000/07/21
Message-ID: <8l8mvh$p54$1@nnrp1.deja.com>#1/1

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

Original text of this message

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