My Oracle Support Banner

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: to - Release: 10.1 to 10.2
Information in this document applies to any platform.


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



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.