Data Import Wizard Problems When Encountering Invalid Date Columns
(Doc ID 2086304.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle SQL Developer - Version 1.5.4 to 4.1
Information in this document applies to any platform.
Import of data to an Oracle table using SQL Developer fails for columns using Date and Time (and DATETIME formats). Further:
- even if Oracle TIMESTAMP data is output to a file and the same data imported, the format is not recognized and must be reselected
- failure to parse DATE, TIME or TIMESTAMP data on import causes subsequent columns to no longer be recognized and mapped by name, and become mapped to the same single column
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document