sqlloader problem
From: Dorothea Kuehn <dekay_at_zedat.fu-berlin.de>
Date: 2000/05/26
Message-ID: <8gmb6b$1jr41$1_at_fu-berlin.de>#1/1
Date: 2000/05/26
Message-ID: <8gmb6b$1jr41$1_at_fu-berlin.de>#1/1
[Quoted] I'm having trouble loading some lengthy textcolumns with sqlldr. The .ctl file looks like this:
load data
infile 'desc.dat'
into table foo.descriptions
fields terminated by X'07' trailing nullcols
(
rid,
description)
The input data file is correctly delimited (linefeeds as record delimiters, the linefeeds in the description texts are replaced). 'rid' is some number, 'description' is of type 'LONG' in Oracle.
If the description text is longer than about 3 lines (255 chars??), the loader rejects the record with:
Field in data file exceeds maximum length.
Why? What can I do to load these data?
(Oracle/SQL*Loader is 8.1.6 for Solaris)
thanks for help,
dekay
Received on Fri May 26 2000 - 00:00:00 CEST