4 Replies Latest reply: Oct 9, 2013 5:23 AM by user11273089 RSS

    Need help regarding sql loader


      Hi ,


      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.