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

Home -> Community -> Usenet -> c.d.o.tools -> Re: How to speedup sqlldr

Re: How to speedup sqlldr

From: frank <fbortel_at_home.nl>
Date: Mon, 02 Oct 2000 20:08:55 GMT
Message-ID: <39D8E973.FCEB39B2@home.nl>

Sybrand, there's actually an option to make dos-boxes scrollable: set the height of the screen buffer size to a larger number (properties, layout), and save that for future windows with the same name.

Sybrand Bakker wrote:

> 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 Mon Oct 02 2000 - 15:08:55 CDT

Original text of this message

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