During Offline Migration With SQL*Loader Error Occurs ORA-01821: Date Format Not Recognized
(Doc ID 1475082.1)
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 .
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!