title: Importing data with SQL * LOADER into two tables
body: <p>I am trying to import data into two tables but the second table cannot be imported. I followed the instruction from online but i dont where the mistake is,</p>
  
  <p>my CTL file is, </p>
  
  <pre><code>-- THIS IS TO LOAD DATA INTO EMPTY TABLE
  LOAD DATA
  INFILE "C:\Component Folder\POWERHOUSEASSYLIST.csv" 
  BADFILE "POWERHOUSEASSYLIST.bad" 
  DISCARDFILE "POWERHOUSEASSYLIST.dsc"
  
  INSERT INTO TABLE "MASTER_DRAWING"
  FIELDS TERMINATED BY ";" OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
  ( 
  HEAD_MARK,
  QTY,
  COMP_TYPE,
  PROFILE,
  SURFACE,
  WEIGHT,
  REV_DATE "SYSDATE",
  REV_NO "1"
  )
  
  INTO TABLE "FABRICATION"
  FIELDS TERMINATED BY ";" OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
  ( 
  HEAD_MARK,
  MARKING "0",
  CUTTING "0",
  ASSEMBLY "0",
  WELDING "0",
  DRILLING "0",
  FINISHING "0",
  REV_DATE "SYSDATE",
  ID "1"
  )
  </code></pre>