My Oracle Support Banner

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 FEBRUARY 03, 2019

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
  Symptoms
  Cause
  Solution
  References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

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