Return
-
Title
How to change date format of text file in Import Wizard? -
Description
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?
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.