Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: HELP:performance for loading data into table.

Re: HELP:performance for loading data into table.

From: Steve Haynes <steve_at_rwx777.demon.co.uk>
Date: Sun, 28 Feb 1999 01:53:39 +0000
Message-ID: <$qAWWCAjGK22Ew1$@rwx777.demon.co.uk>


In article <4a1C2.27$Mi.88830_at_news2.randori.com>, Sihua Luo <luosh_at_yesic.com> writes
>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.
>
>

If you want speed, sqlloader in direct path mode is the only way to go.
Steve
--
Please remove nospam from my address to Reply. Received on Sat Feb 27 1999 - 19:53:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US