Last updated on JANUARY 18, 2017
Applies to:Oracle SQL Developer - Version 3.1 and later
Information in this document applies to any platform.
Using the offline migration, SQL*Loader generates an error on DATE columns
Record 49: Rejected - Error on table DBO_MT2.AGENTS, column CHANGED.
ORA-01821: date format not recognized
It seems to happen with SMALLDATETIME from SQL Server .
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms