Problems With SQL*Loader Files Containing Alphanumeric Date Values During Migration

(Doc ID 269512.1)

Last updated on MAY 31, 2011

Applies to:

Oracle Migration Workbench - Version: 9.2.0.1.7 to 10.1.0.4 - Release: 9.2 to 10.1
Oracle SQL Developer - Version: 1.5 to 3.0   [Release: 1.5.0 to 3]
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

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