My Oracle Support Banner

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.

Symptoms

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

Cause

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
Symptoms
Cause
Solution
References


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