Posted on 2010-01-08
My input file has a certain date field in this format - 01OCT2003:00:00:00,
and it sqlloader I have the date defined as :
INSERT INTO TABLE s48.mytab
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
JOIN_DT DATE 'mm/dd/yyyy',
A_CLOSE_DT DATE 'mm/dd/yyyy',
and I am getting several records rejected -log file shows this as reason --
Record 47: Rejected - Error on table INAL, column JOIN_DT.
ORA-01861: literal does not match format string
Record 48: Rejected - Error on table INAL, column JOIN_DT.
ORA-01843: not a valid month
PLEASE NOTE that I have some columns in the sqlloader without the dattype becuase this table does has some fields as number(8) and some other columns as number