Oracle Database Discussions

Hi:

I am on 10.2.0.3.

Trying to sqlldr a csv file into a table containing about 160 columns - and getting this error ""Token longer than max allowable length of 258 chars".

I already removed most of the functions (to_date, nvl) from the control file, also tried to remove all unnecessary spaces - still getting this error. Please see the control file (up until the column which gives an error), and the error below. Any advise is highly appreciated.

load data infile PS_CV_DEMAND_INV.csv
replace
into table PS_CV_DEMAND_INV
fields terminated by "," optionally enclosed by '"' trailing nullcols
(
BUSINESS_UNIT ,
DEMAND_SOURCE ,
SOURCE_BUS_UNIT,
ORDER_NO,
ORDER_INT_LINE_NO,
SCHED_LINE_NO ,
INV_ITEM_ID ,
DEMAND_LINE_NO,
AUTO_TYPE "nvl(:AUTO_TYPE,' ')" ,
DEMAND_DATE ,
REQUEST_DATE ,
CANCEL_DATE ,
ORIG_SCHED_DATE ,
ORIG_SCHED_TIME ,
SCHED_DATE ,
SCHED_TIME ,
SCHED_ARRV_DTTM,
PICK_DATE ,
ORIG_BU ,
DESTIN_BU "nvl(:DESTIN_BU,' ')" ,
TRANSFER_YIELD ,
DATE_LAST_MAINT ,
LAST_MAINT_OPRID ,
LOAD_ID "nvl(:LOAD_ID,' ')" ,
CARRIER_ID "nvl(:CARRIER_ID,' ')" ,
SHIP_TYPE_ID "nvl(:SHIP_TYPE_ID,' ') ,
SHIP_EARLY_DATE ,
SHIP_EARLY_TIME ,
SHIP_LATE_DATE ,
SHIP_LATE_TIME ,
FREIGHT_TERMS ,
PRIORITY_NBR,
DISTRIB_TYPE,
PICK_BATCH_ID ,
PICKLIST_LINE_NO ,
PROJECT_FLG ,
ACTIVITY_ID ,
RESOURCE_TYPE ,
RESOURCE_CATEGORY ,
RESOURCE_SUB_CAT ,
..........................

SQL*Loader-350: Syntax error at line 45.
Token longer than max allowable length of 258 chars
RESOURCE_SUB_CAT ,
^