title: Loading a huge CSV file with high performance in Oracle table
body: <p>I have a CSV File which its size is about 20 Gig. The file has three Persian columns. I want to load it to Oracle Table. I searched and found that <strong>sql loader</strong> has high performance. But, when I load the file in the table, Persian data is not loaded in the right order. In fact, it is because Persian data is the right to left language.
  I use this control file:</p>
  <pre><code> OPTIONS (SKIP=0, ERRORS=500, PARALLEL=TRUE, MULTITHREADING=TRUE, DIRECT=TRUE, 
   SILENT=(ALL))
   load data
   CHARACTERSET UTF8
   infile '/home/oracle/part.csv'
   APPEND
   into table Fact_test
   fields terminated by ','
   trailing nullcols(
   A_ID INTEGER,
   T_ID,
   G_ID,
   TRTYPE,
   ORRETURNED,
   MECH,
   AMN,
   TRAM INTEGER,
   USERID INTEGER,
   USERS INTEGER,
   VERID INTEGER,
   TRSTAMP CHAR(4000),
   OPR_BRID INTEGER
   )
  </code></pre>
  <p>File is like this:</p>
  <pre><code> A_ID,T_ID,g_id,TrType,ORRETURNED,Mech,Amn,Tram,UserID,UserS,VerID,TRSTAMP,OPR_BRID
   276876739075,154709010853,4302,بروفق,اصلی,غیر سبک,بررسی,86617.1,999995,NULL,NULL,1981-11-16 13:23:16,2516
  </code></pre>
  <p>When I export the table in excel format, I receive this, some numbers become negative:</p>
  <pre><code> (A_ID,T_ID,g_id,TrType,ORRETURNED,Mech,Amn,Tram,UserID,UserS,VerID,TRSTAMP,OPR_BRID) values (276876739075,'154709010853',411662402610,'4302','غیر بررسی','اصلي','سبک',-1344755500,-1445296167,-1311201320,909129772,'77.67',960051513);
  </code></pre>
  <p>The problem is when the data loaded, some columns have negative number and order of some columns change.</p>
  <p>Would you please guide me how to solve the issue?</p>
  <p>Any help is really appreciated.</p>