title: How can I speed up loading data in Oracle tables?
body: <p>I have some very large tables (to me anyway), as in millions of rows.  I am loading them from a legacy system and it is taking forever.  Assuming hardware is ok that is fast.  How can I speed this up?  I have tried exporting from one system into CSV and used Sql loader - slow.  I have also tried a direct link from one system to another so there is no middle csv file, just unload from one load into another.</p>
  
  <p>One person said something about pre-staging tables and that somehow could make things faster.  I don't know what that is or if it could help.  I was hoping for input.  Thank you.</p>
  
  <p>Oracle 11g is what is being used.</p>
  
  <p>update:  my database is clustered so I don't know if I can do anything to speed things up.</p>