Re: sqlloader on NT

Is your original datafile name 8 bytes or less in length (not including file name extension)? If it is greater than 8 bytes, you may want to try explicitly naming the bad file using 8.3 (16-bit) file naming convention ('BAD=badfile.bad'), or referring to the datafile on the sqlldr command line with it's 'shortened' name (the one with the tilde '~' and the number, e.g. referring to 'mylongfilename.dat' as 'mylong~1.dat'). 'DIR' displays both long and short file names.

I've had the exact problem you're describing on NT 3.51 when my file names exceeded 8.3. Either approach above cleared it up.

Good luck,
-Brendan

In article <6qpp6r$e98$1_at_nnrp1.dejanews.com>,   sshealy_at_asgnet.psc.sc.edu wrote:
> I am familiar with using SQL Loader on a UNIX platform but not on NT. I am
> trying to load data in ORACLE 8.0 on NT 4.0 SP3 and am getting the following
> error
>
> SQL*Loader-523: Error -2 writing to file(datafile.bad)
>
> I have checked to make sure that I have permission in the diretory and
> everything. I delete the bad file before trying again but it still won't
> work. BTW I am using the command line.
>
> Any idea why I am getting this error?
>
> Thanks
> Scott
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Aug 11 1998 - 14:07:34 CDT