Re: How to speedup sqlldr

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 1 Oct 2000 09:42:25 +0200
Message-ID: <970386675.16748.2.pluto.d4ee154e@news.demon.nl>

Just type sqlldr and you'll see all the options. If you are using a dos-box and it doesn't fit on one single screen add | more, and the display will stop.

Of course all parameters are also described in the Oracle Server Utilities Manual.

Regards,

Sybrand Bakker, Oracle DBA

"Johan den Boer" <jj.den.boer_at_hccnet.nl> wrote in message news:39D6CE81.504D5FA1_at_hccnet.nl...
> Hi,
>
> I have to load about 400 files into a database. Some files are
> really big. The default for sqlldr is to commit every 64 records.
> Is there a way to change this behaviour in say 256 or 1024 record ?
>
> regards
>
> Johan den Boer
> email : jj.den.boer_at_hccnet.nl
Received on Sun Oct 01 2000 - 02:42:25 CDT