Data Import Wizard Problems When Encountering Invalid Date Columns

(Doc ID 2086304.1)

Last updated on OCTOBER 27, 2016

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms