Re: Sql Loader 8163 prob

From: Bhooshan Prabhu <bhooshan.s.prabhu_at_orbitech.co.in>
Date: 7 Jun 2002 04:40:48 -0700
Message-ID: <16584988.0206070340.5a1ce391@posting.google.com>

Hello,

The read buffer refers to the SQL Loader command line parameter READSIZE=XXXXX. The parameter enables SQL*Loader to perform reads from the external datafile in chunks of XXXXX bytes before a commit is required.

Error 556 does indicate that perhaps the READSIZE has been set to too high and Oracle suggets a workaround of specifying a smaller size. You can find the rather small documentation at http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a90202/ulus.htm

Regards
Bhooshan

---

"Big Kahuna" <guyrstewart_at_mindspring.com> wrote in message news:<adm4lj$ei$1_at_slb6.atl.mindspring.net>...
> Thanks for the help in advance. Had Sql Loader failing previously due to
> file permission and was not mounted (Unix system files - Sun Solaris). When
> file prob straightened out now getting Sql Loader 500. following error is
> Sql Loader 556 - which I can't find documentation on. The error states
> "unable to allocate read buffer". Does anyone know? What read buffer? In
> the db? The unix hosts?
Received on Fri Jun 07 2002 - 06:40:48 CDT