During Offline Migration With SQL*Loader Error Occurs ORA-01821: Date Format Not Recognized
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
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms