SQL*Loader Does A Segmentation Fault (Core Dump) With A Numeric INFILE Name OR Fail With SQL*Loader-503 (Doc ID 472577.1)

Last updated on JANUARY 02, 2008

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 10.2.0.3
This problem can occur on any platform.

Symptoms

When setting the infile parameter to a numeric name inside the control file for the sql*loader utility, it fails with  core dump.

ex.
load data
infile 2000.dat
replace
into table test
fields terminated by ","
trailing nullcols
(col1)

On 9i it used to return the following error instead:

SQL*Loader-503: Error appending extension to file ()
Additional information: 7202





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