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

Hi Gene,

Thank you very much for your suggestion. I'm getting the same error:

ORA-01401: inserted value too large for column

There are line breaks in the data, but they are required as the data needs to be in this format for it to look right in the application. Yes, SQL*Loader is seeing the line breaks as new records because it does a partial load, only pulling the first line of certain rows. I tried to specify a terminating character in the control file for that field in addition to the others, but it didn't make any difference. There is existing data in the database that has this formatting, but I don't know how it was put into the database because it was done by an outside company. Do you know of any other way to load bulk data, where I can keep the formatting?

Or does anyone have any other suggestions?

Thank you and I appreciate your help!!

Alethea

In article <39784050.3789151732_at_news.interpath.net>,   ghubert_at_skillspoint.com (Gene Hubert) wrote:
> 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.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jul 21 2000 - 00:00:00 CDT