sql loader can't write to bad file

From: Brian Weedman <wbrian_at_my-deja.com>
Date: Mon, 25 Oct 1999 12:58:15 GMT
Message-ID: <7v1k56$1eo$1_at_nnrp1.deja.com>


I'm trying to load a file on NT into oracle 8.0.3. I've been doing  this for a while. This weekend I kept getting an error when it went  to write to the bad file (error 2). sql loader is creating the file  but won't write to it. I tested this and created the file and put  data into it no problem. Is there a line length limit on NT and  sql loader?

 The record is failing because one of the fields has data that is  too long to fit in the column.

 Has anyone seen this problem before?

 I don't care about the error records if I don't specify a bad and  discard file in my control file will sql loader stop trying to save  the bad records.

--
Brian Weedman
brianw_at_btsent.com


Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Oct 25 1999 - 14:58:15 CEST

Original text of this message