SQLLdr Return Code

#!/usr/bin/ksh
sqlldr $1 $2 $3 $4 $5 $6 $7 $8 $9 >/tmp/sqlldr.log 2> /tmp/sqlldr.err.log
RETVAL=$?
#                                +-------+-------+------------+
#                                | UNIX  &#124Windows| VMS        
#   +----------------------------+-------+-------+------------+
#   | Successful                 |   0   |   0   | 1          
#   | Unrecoverable failure      |   1   |   3   | %X10000002 
#   | At least one row rejected  |   2   |   2   | 2          
#   | O/S Errors                 |   3   |   4   | 3          
#   +----------------------------+-------+-------+------------+
if [ $RETVAL -eq 2 ]; then
  exit 0;
else
  exit $RETVAL;
fi

window 계열에서 발생한 return value 의미

0 - 성공, 2 - warning, 3 - fail, 4- fatal

출처 : 이정주

http://www.orafaq.com/forum/t/37254/0/