My Oracle Support Banner

Data Import Wizard Problems When Encountering Invalid Date Columns (Doc ID 2086304.1)

Last updated on FEBRUARY 25, 2021

Applies to:

Oracle SQL Developer - Version 1.5.4 to 4.1
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.