Please let me know what is wrong with the following control file
append into table test1
fields terminated by ',' optionally enclosed by '"'
INQ_DATE date "yyyy-mm-dd",
FIRST_FOLL date "yyyy-mm-dd",
SEC_FOLL date "yyyy-mm-dd",
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
What is the error you get?
Life is a journey, not a destination!
ORA-01401: inserted value too large for column
Then, determine if the data you are trying to insert is longer than a value is allowed for a particular column.
OCP 8i, 9i DBA
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:
hope that works.
HI is your
the right way round the data is
Not sure what kind of descriptions you use for inq_status but Employment News appears to be a Media name.
You'll always learn something if you take your time to ask.
Click Here to Expand Forum to Full Width