| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: sqlldr problem
In your control file you must declare the input length as in the following example:
create table test_ldr (
a varchar2 (4000) , b varchar2 (4000)
Then your controlfile should look like
load data
truncate into table test_ldr
(
a position (1) char (4000) terminated by ";" , b position (*) char (4000) terminated by ";")
The char (4000) tells the loader the maximum length it has to provide for.
Martin
akvalang_at_my-deja.com wrote:
>
> Hello.
>
> I am using Oracle 8.1.6 on Solaris 7. I am trying to load a comma-
> delimited text file that has about 800 columns into one table using sql
> loader. And I get the following error 50 times for each record (I have
> a couple of hundred records total in the file), and none of the records
> get loaded.
>
> Record 1: Rejected - Error on table TABLE_NAME, column COLUMN_NAME.
> Field in data file exceeds maximum length
>
> COLUMN_NAME has 3240 characters in each of the fields in the inputfile,
> and it is defined as VARCHAR2(4000) in the destination table and as
> CHAR in the sql loader control file. So it "should" have enough space
> for the whole record.
>
> Do you have any ideas on what the problem here might be.
> I would appreciate any help.
>
> Thanks in advance.
> Alex.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sun May 07 2000 - 00:00:00 CDT
 |
 |