During Offline Migration With SQL*Loader Error Occurs ORA-01821: Date Format Not Recognized
(Doc ID 1475082.1)
Last updated on JANUARY 18, 2017
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!
In this Document
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|