Sqlldr With @ in Filename Raises Sql*Loader-502
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Server - Standard Edition - Version: 126.96.36.199
Information in this document applies to any platform.
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:
Into Table TC.XMLLoad replace
Fields Terminated By ',' Optionally Enclosed By '"'
Content LOBFile(File) Terminated By EOF
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