Hello. I have a table that I wanted to load a CSV file into

1 CREATE TABLE "TMS_DEF_ACTIONS" ("DEF_ACTION_KEY"
2 VARCHAR2(15) NOT NULL, "CREATION_TS" DATE NOT NULL,
3 "CREATED_BY" VARCHAR2(30) NOT NULL, "ACTION_TYPE"
4 VARCHAR2(15) NOT NULL, "DEFAULT_TEXT" VARCHAR2(2000),
5 "MODIFICATION_TS" DATE, "MODIFIED_BY" VARCHAR2(30),
6 CONSTRAINT "TMS_DEF_ACTIONS_PK" PRIMARY KEY("DEF_ACTION_KEY")

and I wanted to load the following csv data that I extracted
"CLARIFY ","21.04.2004 11:03:04","OPS$KOO ","C ","Please clarify this term. "," "," " "SPLIT ","21.04.2004 11:03:04","OPS$KOO ","N ","There is more than one medical concept. Please split for accurate coding. "

I put this controlfile together
LOAD DATA
INFILE 'TMS_DEF_ACTIONS.lst'
INTO TABLE TMS_DEF_ACTIONS
FIELDS TERMINATED BY ","
TRAILING NULLCOLS
(

DEF_ACTION_KEY CHAR NULLIF (DEF_ACTION_KEY=BLANKS)
, CREATION_TS DATE "MM/DD/YY" NULLIF (CREATION_TS=BLANKS)
, CREATED_BY CHAR NULLIF (CREATED_BY=BLANKS)
, ACTION_TYPE CHAR NULLIF (ACTION_TYPE=BLANKS)
, DEFAULT_TEXT CHAR NULLIF (DEFAULT_TEXT=BLANKS)
, MODIFICATION_TS DATE "MM/DD/YY" NULLIF (MODIFICATION_TS=BLANKS)
, MODIFIED_BY CHAR NULLIF (MODIFIED_BY=BLANKS)

but i am gettign errors..

QL*Loader: Release 9.2.0.6.0 - Production on Tue Jun 21 15:12:22 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Control File: tms_def_actions.ctl
Data File: TMS_DEF_ACTIONS.lst
Bad File: TMS_DEF_ACTIONS.bad
Discard File: none specified

(Allow all discards)

Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array: 64 rows, maximum of 256000 bytes
Continuation: none specified
Path used: Conventional

Table TMS_DEF_ACTIONS, loaded from every logical record.
Insert option in effect for this table: INSERT
TRAILING NULLCOLS option in effect

Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
DEF_ACTION_KEY FIRST * , CHARACTER
NULL if DEF_ACTION_KEY = BLANKS
CREATION_TS NEXT * , DATE MM/DD/YY
NULL if CREATION_TS = BLANKS
CREATED_BY NEXT * , CHARACTER
NULL if CREATED_BY = BLANKS
ACTION_TYPE NEXT * , CHARACTER
NULL if ACTION_TYPE = BLANKS
DEFAULT_TEXT NEXT * , CHARACTER
NULL if DEFAULT_TEXT = BLANKS
MODIFICATION_TS NEXT * , DATE MM/DD/YY
NULL if MODIFICATION_TS = BLANKS
MODIFIED_BY NEXT * , CHARACTER
NULL if MODIFIED_BY = BLANKS

Record 1: Rejected - Error on table TMS_DEF_ACTIONS, column DEFAULT_TEXT.
Field in data file exceeds maximum length
Record 2: Rejected - Error on table TMS_DEF_ACTIONS, column DEF_ACTION_KEY.
Field in data file exceeds maximum length
Record 3: Rejected - Error on table TMS_DEF_ACTIONS, column DEF_ACTION_KEY.
Field in data file exceeds maximum length
Record 4: Rejected - Error on table TMS_DEF_ACTIONS, column DEFAULT_TEXT.
Field in data file exceeds maximum length
Record 5: Rejected - Error on table TMS_DEF_ACTIONS, column DEF_ACTION_KEY.
Field in data file exceeds maximum length
Record 6: Rejected - Error on table TMS_DEF_ACTIONS, column DEF_ACTION_KEY.
Field in data file exceeds maximum length

Table TMS_DEF_ACTIONS:
0 Rows successfully loaded.
6 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.


any ideas?

thanks