sqlldr and large text files

From: Lisa M. Lewis <lmg_at_isdsa.pgh.wec.com>
Date: 1997/06/24
Message-ID: <33AFFDBB.70A247BF_at_isdsa.pgh.wec.com>#1/1


I am trying to load a larger ( > 256 and < 500 ) character string with sqlldr. I am using d:\orant\bin\sqlldr73.exe ( 3/8/97). It is not working and I'm not sure why. I have read the previous posts on this topic and feel that I have complied. Can anyone help?

The error I get is as follows in the log file:

Record 15384: Rejected - Error on table LOCATIONS, column LOCATION ORA-02359: Field in data file exceeded maximum specified length

The following entry ends up in the bad file:

"/regional/countries/canada/provinces_and_territories/ontario/counties_and_regions/greater_toronto_area__gta_/metropolitan_toronto/north_york/education/colleges_and_universities/york_university/departments_and_programs/writers_in_electronic_residence__wier__program/" 35702

My control file looks like:

OPTIONS (ROWS = 20000, ERRORS=10000 )
UNRECOVERABLE
LOAD DATA
INFILE 'E:\YAHOO\IMPORT\NewLocation.map' BADFILE 'E:\YAHOO\IMPORT\NewLocation.bad' DISCARDFILE 'E:\YAHOO\IMPORT\NewLocation.dsc' APPEND
INTO TABLE locations
FIELDS TERMINATED BY X'09' OPTIONALLY ENCLOSED BY '"' (LOCATION,LOCMAPID CHAR(512)) Thanks for your time,

Lisa Received on Tue Jun 24 1997 - 00:00:00 CEST

Original text of this message