Home » RDBMS Server » Server Utilities » sqlldr parameters to handle SQL*Loader-500: Unable to open file
sqlldr parameters to handle SQL*Loader-500: Unable to open file [message #377720] Wed, 24 December 2008 10:53 Go to next message
ora1980
Messages: 251
Registered: May 2008
Senior Member
I deliberately removed my data file, and ran sqlldr
as expected, I got the following error


SQL*Loader-500: Unable to open file (S:\abc\xyz\data\tbl_emp.csv)
SQL*Loader-553: file not found
SQL*Loader-509: System error: The system cannot find the file specified.



is there any sqlldr commandline parameter to handle the above error?
I was looking for the following parameters

RAISE_ERROR_NO_DATA_FILE
RAISE_ERROR_ON_BAD_DATA

but they are not there in the sqlldr command line list...
Re: sqlldr parameters to handle SQL*Loader-500: Unable to open file [message #377746 is a reply to message #377720] Wed, 24 December 2008 16:42 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>but they are not there in the sqlldr command line list...
You answered your own question.
You can write a batch file with your favorite scripting language to catch any exit codes/errors.
Previous Topic: Error during import
Next Topic: Transportable tablespaces
Goto Forum:
  


Current Time: Fri Dec 02 22:47:06 CST 2016

Total time taken to generate the page: 0.11605 seconds