Re: Help!! Oracle SQL*LOADER can't write to the bad file

From: Frido van Orden <fridoo_at_faapartners.com>
Date: Tue, 15 Aug 2000 09:24:19 +0200
Message-ID: <8nar9h$kui$1@nereid.worldonline.nl>

Disk full? No write permision on file? Read-only file?

"JOHN COOPER" <jicooper_99_at_yahoo.com> wrote in message news:LQfl5.2443$ks4.47887_at_news.itd.umich.edu...
> I am using sql*loader 8.1.5 to load some large data record, with variable
> record size.
> (some records have many varray items, say thousands)
> however, after several commit points, it shows:
>
> Commit point reached - logical record count 15
> Commit point reached - logical record count 27
> Commit point reached - logical record count 42
> Commit point reached - logical record count 45
> SQL*Loader-523: error -2 writing to file (BAD.REJ)
>
>
> Could that be BINDSIZE/READSIZE problem?
> But when I tried to set the bandsize/readsize to a large number, it
> reported:
>
> SQL*Loader-500: Unable to open file
> OSD-04301: record size too large
>
> what's wrong with this?
>
> I am using the Enterprise version on win2k server.
>
> Any help will be greatly appreciated!!
>
> Thanks!!
>
>
>
>
>
>
>
>
Received on Tue Aug 15 2000 - 02:24:19 CDT