OraFAQ Forum: Server Utilities » sqlldr parameters to handle SQL*Loader-500: Unable to open file

Home » RDBMS Server » Server Utilities » sqlldr parameters to handle SQL*Loader-500: Unable to open file

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sqlldr parameters to handle SQL*Loader-500: Unable to open file [message #377720]

Wed, 24 December 2008 10:53

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...

Report message to a moderator

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

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Previous Topic:	Error during import
Next Topic:	Transportable tablespaces

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 12 06:08:55 CST 2025