title: Commit point reached
body: <p>Hi I'm trying to load some data in to an Oracle Table I created</p>
  
  <p>Here's the table I created in Vivek schema</p>
  
  <p>Desc STAR</p>
  
  <pre><code>Name                       NULL       TYPE
  -----------------------------------------------------
  STAR_ID                    Not Null    Number(4)
  FIRST_NAME                             Varchar2(30)
  LAST_NAME                              Varchar2(30)
  DOB                                    Date
  SEX                                    Char(1)
  Nationality                            Varchar2(40)
  Alive                                  Char(1)
  </code></pre>
  
  <p>Following is the data in the STAR5.CSV file I am trying to upload using SQL Loader</p>
  
  <pre><code>10,NASEERUDDIN,SHAH,M,INDIAN,Y
  11,DIMPLE,KAPADIA,F,INDIAN,Y
  </code></pre>
  
  <p>The control file is as follows</p>
  
  <pre><code>load data
   infile '/home/oracle/host/Vivek12/STAR_DATA5.csv'
  append
  into table vivek.STAR
  fields terminated by "," 
  ( STAR_ID,FIRST_NAME,LAST_NAME,SEX,NATIONALITY,ALIVE )
  </code></pre>
  
  <p>When I run the SQL Loader with the following command</p>
  
  <pre><code>$ sqlldr vivek/password
  control = /home/oracle/sqlldr_add_new.ct1
  </code></pre>
  
  <p>I get the message:</p>
  
  <p>Commit point reached - logical record count 2</p>
  
  <p>However the data is not loaded and the are put in the file <code>STAR5.bad</code></p>
  
  <p>Any idea why the data isn't getting loaded?</p>