how to handle sql loader errors in unix

Shell Programming and Scripting
1

hi all,

how to handle sql loader errors in unix shell

??

thanks in advance
gemini

2

you might want to elaborate some...

3

hi all,

i got error while loading sqlloader
that goes to 'filename.log' file of that sqlloader ,
but i cat captuer that error in unix , using $? mark ,
how to handle that ???

4

Well, if you've got it going to a log file, you're halfway there. sqlldr is pretty self-contained in that regard..it's pretty self-explanatory when it does log (well, with oerr assistance maybe). You can either check or grep your .log file for further instructions, as it might just be a hiccup in your data, or perhaps an append gone horribly wrong. However, you're not likely to see much of a $? failure..it's logged already, which means the app ran. You'd probably see an exit of 0.

Otherwise, it might help your question to post either your session's screen output, or your sqlldr call, or your sqlldr log, or all three.