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

JOHN COOPER wrote:
>
> 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

This may be the known bug we hit in 8.0.5 (fixed in both 8.0.6 and 8.1.6) - when writing to the bad file, if the file grows beyond a certain size (I believe somewhere around 200K), sqlloader errors out with a sqlloader-523 error.
If you have access to metalink, search on bug 738397.

Cheers,
GC Received on Mon Aug 14 2000 - 19:00:34 CDT