sql loader error

[star]

Hai friends

Please let me know what is wrong with the following control file
load data
infile *
badfile 'c:\test\test.bad'
discardfile 'c:\test\test.bad'
append into table test1
fields terminated by ',' optionally enclosed by '"'
(INQ_NO integer,
FNAME,
LNAME,
HOME_TEL "replace(:home_tel,'-')",
WORK_TEL "replace(:work_tel,'-')",
EMAIL,
INQ_DATE date "yyyy-mm-dd",
FIRST_FOLL date "yyyy-mm-dd",
SEC_FOLL date "yyyy-mm-dd",
NO_FOLL,
INQ_TYPE,
ATTENDED_BY,
REMARKS,
INQ_STATUS,
MEDIA_ID
)
begindata
2501,"Abcd","Efg","1112223333","","",2001-03-30,2001-04-03,2001-04-07,3,"Personal Visit","Aaaa","Good Came in today interested in e-business pre-emp will call us.askinf for Unix & oracle Not sure when & what course he will start told him C++ & java - 3 april","Employment News",1

thanks

[sambavan]

What is the error you get?

Sam

[star]

Hai Sam,

ORA-01401: inserted value too large for column

Thanks

[grjohnson]

Do a

DESC TEST1;

Then, determine if the data you are trying to insert is longer than a value is allowed for a particular column.

Cheers,

[jgmagnus]

LOOKS LIKE it's your 'remarks' field.
you need to specify how many characters that field is going to be.
edit your loader file to the length of that column like below:

REMARKS char(2000),


hope that works.
- Magnus

[Grah]

HI is your

INQ_STATUS,
MEDIA_ID

the right way round the data is
"Employment News",1

Not sure what kind of descriptions you use for inq_status but Employment News appears to be a Media name.