Hi, I am using Oracle 8.0.4 on Solaris 2.6. Trying to load data from a text file to a table using SQL*Loader. Receiving the following error during the load: SQL*Loader-523: error-2 writing to file (/mnt/voyager/ccuser/ccuser.bad) The load.shl file contains bad file parameter: BAD=$DIR/$FILENAME.bad \ Tried changing permissions on .bad file from: -rwx------ to -rw-r--r--. Still receive error. We are using fixed position records. The errant record is too short. I have also tried adding TRAILING NULLCOLS to the control file, but the error still occurs. Any ideas? Thanks, Michelle __________________________________________________ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michelle Buyer INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
