Sqlloader Fails With ORA-604 And ORA-1861 When Loading Date Fields And Using Direct=Y (Doc ID 780525.1)

Last updated on JULY 21, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.3 to 10.2.0.4 - Release: 10.1 to 10.2
Information in this document applies to any platform.

Symptoms

When attempting to perform a direct load of data containing date fields with Sqlloader, it fails when loading the date fields with errors:

ORA-00604: error occurred at recursive SQL level 1
ORA-01861: literal does not match format string

.

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