Hi,
I am running the below script from unix and the sqlloader command fails, Can I request to let me know how to handle this error.
My Code:
sqlldr userid="$1" control=Control/$l_control
.control.t
xt data="$2/$p.txt" log=log/$v_log.log bad=log/$v_log.bad silent=header,feedback
retcode=`echo $?`
echo $retcode
case "$retcode" in
0) echo "SQL*Loader execution successful" ;;
1) echo "SQL*Loader execution exited with EX_FAIL, see logfile" ;;
2) echo "SQL*Loader exectuion exited with EX_WARN, see logfile" ;;
52) echo "SQL*Loader Discarding some rows, but I do not care " ;;
3) echo "SQL*Loader execution encountered a fatal error" ;;
*) echo "unknown return code";;
esac
echo "Data Load Completed successfully for " $t $p
But still I am unable to handle the below error, I need to ignore any bad records and progress further. Please suggest
Record 1872: Rejected - Error on table DWDM_SUBRACK.
ORA-00001: unique constraint (T2100.DWDM_SUBRACK_PK) violated