sqlldr ORA-01861: literal does not match format string
I am having such a hard time getting 5 rows loaded. There are It seems to complain about the date format. I had it defined as date and the date is like "2007-05-01" so in sqlldr ctl file, i do
STATUS_DATE DATE "YYYY-MM-DD"
and keep on getting the following error:
value used for ROWS parameter changed from 64 to 33
Record 1: Rejected - Error on table HEALTHNET_APPLICATION, column STATUS_DATE.
ORA-01861: literal does not match format string
0 Rows successfully loaded.
1 Row 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.
Space allocated for bind array: 255420 bytes(33 rows)
Read buffer bytes: 1048576
Total logical records skipped: 0
Total logical records read: 1
Total logical records rejected: 1
Total logical records discarded: 0
Can anyone help with the date format? Thanks.
Click Here to Expand Forum to Full Width