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


Table HEALTHNET_APPLICATION:
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.