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

Home -> Community -> Usenet -> c.d.o.server -> Re: Help!! Oracle SQL*LOADER can't write to the bad file

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

From: Roger Palmen <r.palmen.ani_at_alewijnse.nl>
Date: Fri, 18 Aug 2000 11:31:51 +0200
Message-ID: <399D0287.4E2C922@alewijnse.nl>

Somehow Oracle thinks I don't have a license, so I can't view the bug. Anyone like to copy-paste it to me?

GC wrote:

> 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 Fri Aug 18 2000 - 04:31:51 CDT

Original text of this message

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