My Oracle Support Banner

Problems With SQL*Loader Files Containing Alphanumeric Date Values During Migration (Doc ID 269512.1)

Last updated on OCTOBER 17, 2019

Applies to:

Oracle SQL Developer - Version 1.5 to 3.0 [Release 1.5.0 to 3]
Oracle Migration Workbench - Version 9.2.0.1.7 to 10.1.0.4 [Release 9.2 to 10.1]
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
***Checked for relevance on 31-May-2011***

Symptoms

SQL*Loader fails to load alphanumeric date values on Unix if the environment variable  NLS_DATE_FORMAT has been set.
The error returned is:

ORA-1858: a non-numeric character was found where a numeric was expected

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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.