This content has been marked as final. Show 4 replies
I am executing following command
sqlldr admin_user@ces CONTROL=D:\sample_control.ctl log=D:\sample_log.log bad=D:\Sample_bad.bad
In case of valid data it is inserting the data properly into the table. While invalid records added into the bad file.
Now I want rollback valid data whenever count of bad file greater than equal to 10.
In short whenever file has more than 10 invalid records , I don't want to insert any record from that file.
Please provide me the solution.Thanks in advance.