4 Replies Latest reply: Oct 9, 2013 5:15 AM by Karthick_Arp RSS

    Need help regarding sql loader

    user11273089

      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.