Re: How do I change the readsize on SQL*Loader?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 7 Mar 2001 21:57:55 +0100
Message-ID: <tad8aq20rd2he4@beta-news.demon.nl>

"Calvin Crumrine" <Calvin_Crumrine_at_dced.state.ak.us> wrote in message news:3AA68F07.699C2B0E_at_dced.state.ak.us...
> Release 8.1.5.0.0
> Getting the message 'Readsize (65535) less than bindsize (100000)'.
> Readsize doesn't seem to be documented-how can I change it to match the
> bindsize?
>
> Thanks.
>

buffer=<bytes> Loader determines the bindsize from the buffer. Chances are however you run on NT and you just hit the dratted 64k limit. BTW 8.1.5 has been desupported.

Hth,

Sybrand Bakker, Oracle DBA Received on Wed Mar 07 2001 - 14:57:55 CST