Re: HELP:performance for loading data into table.

From: Steve Phelan <stevep_at_toneline.n-o-s-p-a-m.demon.co.uk>
Date: Sun, 28 Feb 1999 11:17:23 +0000
Message-ID: <36D925C3.1D5ACD1A@toneline.n-o-s-p-a-m.demon.co.uk>

I'd strongly suggest SQL loader. Use the 'direct' mode for maximum performance. Your million records could be inserted in a matter of minutes, though index builds will take longer. Have a good read of the Oracle utilities manual first to note the restrictions/impact of 'direct' mode. We use SQL Loader for loading 100's of millions of records into our databases without problems.

Steve Phelan.

Sihua Luo wrote:

> Hi, All,
> I have performance tuning to load bulk data (over million records
> stored in a flat file) into table. Would you mind show me which of
> following is best.
> Method One: use Proc*C code to insert(update) data into table.
> Method Two: use Sqlloader.
> Any comment will be helpful to me. Thanks in Advance.
>
> Frank Luo.
Received on Sun Feb 28 1999 - 05:17:23 CST