How to import Date column using SQL Loader Interface ? (4334023)

Toad
When using SQL Loader Interface to import the Date column, usually, users will get an error : ORA 01843 indicated invalid Month or Date related error.

This occurs because the date format of imported data is incompatible with the database date format. Therefore, Oracle didn't recognize the imported data as a valid date.

Resolution:
With in SQL Loader Wizard :
1. After adding the table for importing data, highlight the Date column
2. Now Click on Column Parameter Tab , Pick Date for Datatype Field and write the format of the imported date into the Date Mask Field.