During Offline Migration With SQL*Loader Error Occurs ORA-01821: Date Format Not Recognized
(Doc ID 1475082.1)
Last updated on MAY 11, 2022
Applies to:
Oracle SQL Developer - Version 3.1 and laterInformation in this document applies to any platform.
Symptoms
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 .
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 |