title: How to rollback when an error occurs while executing sql loader command?
body: <p>If while loading this file </p>
  
  <pre><code>$ cat employee.txt
  100,Thomas,Sales,5000
  200,Jason,Technology,5500
  300,Mayla,Technology,7000
  400,Nisha,Marketing,9500
  500,Randy,Technology,6000
  501,Ritu,Accounting,5400
  </code></pre>
  
  <p>using the control file (say) sqlldr-add-new.ctl I came to know all the records are faulty so I want the previously loaded records in that table (those that were loaded yesterday) to be retained if today's had any error. How to handle this exception.</p>
  
  <p>This is my sample ctl file</p>
  
  <pre><code>$ cat sqlldr-add-new.ctl
  load data
  infile '/home/ramesh/employee.txt'
  into table employee
  fields terminated by ","
  ( id, name, dept, salary )
  </code></pre>