faster than SQLLOADER

From: Mohammed Ghouse <mghous1_at_mason1.gmu.edu>
Date: 31 Dec 1994 15:48:59 GMT
Message-ID: <3e3uhb$1q8_at_portal.gmu.edu>


Is there any other method to load 3 million records of 100 reclength into a table already having 60 million records. We need to have an index of a key of length 17. What I need is a method

  1. Which is faster than SQL loader with DIRECT PATH
  2. with less space requirment (speed is more imporatant)
  3. Dropping and recreating of index can be considered if there is an advantage. One of the oracle consultants says that exp /import is faster. He says that a file with exp format can be created through c program which in turn can be imported. Is it practicable? and wheteher there is any speed advantage in this method.

Thanks for any expert advice on this. Received on Sat Dec 31 1994 - 16:48:59 CET

Original text of this message