title: Best way to export huge data from Oracle DB to Oracle DB
body: <p>That's my first post in stackoverflow, and i've to say that i really like that website !</p>
  
  <p>For a project i need to export then re-import some huge Oracle tables from one DB to another (around 100 million lines and 30 rows).</p>
  
  <p>My idea is to export the table in a flat file and then reimport into another empty table considering that the schema already exists.</p>
  
  <p>I'm using PL/SQL Developer and/or SQL*Plus to make my operations.</p>
  
  <p>I've tested SQL*Loader which seems to do a good job but it's really slow in my opinion : about 30 seconds to make an import of a CSV file with 1 million lines/30 rows.</p>
  
  <p>Which solution could you bring? Is SQL*Loader is the best tool? Some better tools already exists?
  Is CSV the better format talking about size and processing time?</p>
  
  <p>Thanks a lot in advance.</p>