Re: SQL*Loader-523: error -2 writing to file (badfile)

not sure whether loader handles extended file names correctly. Try doc.bad for a name, not doc.wet.bad, as well as SQLLOAD (less than 8 chars) for directory (DOS naming convention!)

SQL*Loader-523: error num writing to file (name)

Cause: Could not write to specified file.

Action: Check the following:

          the file actually resides in the specified location 
          you have write privileges on the file 
          you have sufficient disk space 
          you have not exceeded your disk quota 

Hth, rgds, Frank
Tom Wouters wrote:
>
> I'm using SQL*Loader to load long (delimited) records into my database.
>
> If there happens to be an error in one of the datarecords to be loaded,
> and this same data records happens to have a length greater than EXACTLY
> 57Kb, then SQL*Loader terminates with an error:
>
> SQL*Loader-523: error -2 writing to file
> (c:\backup\SQLloader\doc.wet.bad)
>
> If on the other hand the datafile doesn't contain any records - longer
> than 57Kb - that cause an error, SQL*Loader does the job perfectly.
>
> Has anybody an idea? Is this a known bug?
>
> Tom
Received on Wed Aug 23 2000 - 09:57:09 CEST