SQL*Loader - error writing to bad file

From: Michelle Buyer <mbuyer1_at_yahoo.com>
Date: Wed, 14 Mar 2001 13:11:30 -0800
Message-ID: <F001.002CCA0B.20010314104524@fatcity.com>

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: mbuyer1_at_yahoo.com

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: ListGuru_at_fatcity.com (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). Received on Wed Mar 14 2001 - 15:11:30 CST