Sqlldr With @ in Filename Raises Sql*Loader-502 (Doc ID 1294002.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Standard Edition - Version: 11.2.0.1 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms

You are using sql*loader to load data.
Your sql*loader scripts worked fine in 10g
In 11g, they fail with the following type of error messages:
 SQL*Loader-502: unable to open data file '/home/oracle/john.doev112oracle.com.xml'
   for field CONTENT table TC.XMLLOAD
SQL*Loader-553: file not found
SQL*Loader-509: System error: No such file or directory
...
with <loader.ctl> being:
Load Data
InFile *
BADFILE '/home/oracle/XML_bad.bad'
Into Table TC.XMLLoad replace
Fields Terminated By ',' Optionally Enclosed By '"'
Trailing NULLCols
(
            Process Char,
            File Filler,
            FileName Char,
            Content LOBFile(File) Terminated By EOF
)
BeginData
newuser,/home/oracle/john.doe@oracle.com.xml,john.doe@oracle.com.xml,
newuser,/home/oracle/john.doe2@oracle.com.xml,john.doe2@oracle.com.xml,

Changes

You upgraded from 10g to 11g

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