sqlldr

http://www.orafaq.com/forum/t/146582/ 

Thank you for your reply. Load has been successful all the time but I should not check the error condition (since I know there are going to be some errors) in order to continue the process I guess. But adding errors=9999999 and checking the error condition with $? will have the same result which will abort the process.
I really appreciated your time/effort in replying to my questions. Thanks very much and have a great day!

Hi pls provide your suggestion,

I'm using following command to th data.

sqlldr callctestapp/big5#ben@COMPASS_QA_APP, control=./EOBReportMember.ctl, log=../logs/reportMember.log, ERRORS=9999999

Flat file have 3 records, among hem 1 is dplicate. So two records are ussesfully loaded into the table.


But while running echo $? it give 2. Hence the script is getting failed. Can you please give your suggetion on this. Thanks in advance

Just curious where you saw error code 2 is incorrect usage of command? The documentation indicates that it's one of the following:

• All or some rows rejected
• All or some rows discarded
• Discontinued load

Error code 1 would indicate "Command-line or syntax errors".