Unanswered: ORA-01843: not a valid month (need solution on CTL file)
I have an interface managed by a CTL file. The interface is between the data source and the Datawarehouse.
Some days ago a date field of the source table is changed from mm-dd-yyyy to the new format yyyy-mm-dd
in the CTL file I have this field:
The problem is that when the database returns: ORA-01843: not a valid month
The solution that I have to implement is manage the data conversion in the CTL file in order to provide to the datawarehouse the date in the correct format (mm-dd-yyyy). But I don't know what I have to add in my CTL File.
As far as I understood, recently the date format has changed and now it is YYYY-MM-DD. This is the format mask you need to apply in the control file.
It would be easier to discuss if you provided a test case. It includes description of a target table (what is, for example, LAST_UPDATE_DATE column's datatype. I *hope* it is a DATE, and not a VARCHAR2 column). What is the input (that would be several lines from your CSV file, just as I wrote in the BEGINDATA section of my control file). Include any relevant information.