title: SQL Loader : Load into 2 Tables from 1 controlfile and 1 CSV
body: <p>Table T1 Structure:col1 number,col2 number</p>
  
  <p>Table T2 Structure: col1 number,col2 number,col3 number</p>
  
  <p>csv file:</p>
  
  <pre><code>row1:1,2,3,4,5,6
  row2:1,2,3,4,5,6
  </code></pre>
  
  <p>I want data in Table T1 as:</p>
  
  <pre><code>col1   col2
  =====  ====
  1       3
  1       3
  </code></pre>
  
  <p>I want data in Table T2 as:</p>
  
  <pre><code>col1   col2   col3
  =====  ====   ==== 
  1       3       5
  1       3       5
  </code></pre>
  
  <p><strong>following control file is not working</strong></p>
  
  <pre><code>load data
  infile *
  insert into table T1 fields terminated by ',' TRAILING NULLCOLS 
  (col1,fill1 filler,col2)
  insert into table T2 fields terminated by ',' TRAILING NULLCOLS
  (col1,fill2 filler,col2,fill3 filler,col3)
  begindata
  1,2,3,4,5,6
  1,2,3,4,5,6
  </code></pre>
  
  <p>Please help me to  solve this problem.</p>