I have table with a column defined like INSTATE_DATE DATE I have to laod the data frm the csv file to this table. my csv file has data 00/00/0000. Even though it is an invalid date I have load this date to my oracle table. I have an option of loading a default value say 01/01/2010 everytime i come across 00/00/0000. I tried to modify the control file like INSTATE_DATE DATE "replaceINSTATE_DATE,'00/00/0000','01/01/2010')" Even then im getting the error "ORA-01821: date format not recognized" Please let me know if there are any other way to achive this.