Re: SQL-LOADER ERROR

The problem is that the back releases (8.0.3 and lower) of SQLLDR apparently cannot write a record to the BAD file that is over 270 characters long.

As the other poster said, known bug fixed in 8.0.4/5.

In article <6vfsee$3lh$1_at_nnrp1.dejanews.com>,   psylvestre_at_my-dejanews.com wrote:
> Thank you for your response,
>
> I've check all this points, but there's nothing to do, it still not work.
>
> If there's any solutions, do you know where i can downloading the Oracle 8.04
> releases or upgrade.
>
> Thanks in advance.
>
> In article <361B3E3B.3D18_at_respironics.com>,
> Colm Hoban <colm.hoban_at_respironics.com> wrote:
> > psylvestre_at_my-dejanews.com wrote:
> > >
> > > Hello,
> > >
> > > What does this mean ?
> > > SQL*Loader-523: Error -2 writing to file (I:\BD\VILLES\ORACLE7
> > > \RELOAD\RESULTAT\FAC9917.BAD)
> > >
> > > Thanks in advance.
> > >
> > > -----------== Posted via Deja News, The Discussion Network ==----------
> > > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
> >
> > Check the following:
> >
> > 1 the file actually resides in the specified location
> >
> > 2 you have write privileges on the file
> >
> > 3 you have sufficient disk space
> >
> > 4 you have not exceeded your disk quota
> >
> > I have also seen this in 8.03 as a known bug - the solution - upgrade to
> > 8.04
> > HTH
> > Colm Hoban
> >
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Oct 08 1998 - 07:55:27 CDT