User using Import Wizard to import a text file into an Oracle table. Text file contains date values corresponding to Date data type column of Oracle table. Dates in text file are a different format (dd-mm-yyyy) than the Oracle database NLS Date Format (mm/dd/yyyy). Therefore Import causes an error:
"Failed inserting from row #0 to #3 without detailed row number info : ORA-01843 not a valid month"
How to change the date formats in import wizard in order to import date values properly to the table?
1. Select Tools | Options menu option
2. Select Environment | Grid from left side tree
3. On the right side, under Data Type Formatting section, check Custom checkbox
4. In the field next to Custom checkbox, enter the below as exact with specified casing:
dd/MM/yyyy
5. Notice the date displayed changed properly. Hit OK to exit window.
*Note: Custom date entry field is case sensitive and values have to be entered with the above casing. To perform a test, run "select sysdate from dual" in Editor window to ensure date format is properly entered
