title: How to do BULK INSERT in Oracle Database
body: <p>I am trying to do a bulk insert into tables from a CSV file using Oracle11. My problem is that the database is on a remote machine which I can sqlpl to using this:</p>
  
  <pre><code>sqlpl username@oracle.machineName
  </code></pre>
  
  <p>Unfortunately the <code>sqlldr</code> has trouble connecting using the following command:</p>
  
  <pre><code>sqlldr userid=userName/PW@machinename control=BULK_LOAD_CSV_DATA.ctl log=sqlldr.log
  </code></pre>
  
  <p>Error is:</p>
  
  <pre><code>Message 2100 not found; No message file for product=RDBMS, facility=ULMessage 2100 not found; No message file for product=RDBMS, facility=UL
  </code></pre>
  
  <p>Now having given up on this approach I tried writing a basic sql script, but I am unsure of the proper Oracle keyword for <code>BULK</code>. I know this works in MySql but I get:</p>
  
  <pre><code>unknown command beginning "BULK INSER..."
  </code></pre>
  
  <p>When running the script:</p>
  
  <pre><code>BULK INSERT &lt;TABLE_NAME&gt;
  FROM 'CSVFILE.csv'
  WITH
  (
      FIELDTERMINATOR = ',',
      ROWTERMINATOR = '\n'
  )
  GO
  </code></pre>
  
  <p>I don't care which one works! Either one will do, I just need a little help.</p>