Re: SQL*LOADER problem

Dave,

	Let me re-phrase the question to be more clear.
	What I don't want to know is which row is in error.
	ORACLE goes to great lengths to tell me that.
	E.g. log file tells me the following:
		Record 2: Rejected - Error on table JUNK.
		ORA-01401: inserted value too large for column
	But, the real question is WHICH COLUMN??? 
	
		parris

Dave Marcus (dmarcus_at_notes.cc.bellcore.com) wrote:
> In article <48i6mm$qgq_at_athos.cc.bellcore.com>, parris@walleye.esp.bellcore.com
> says...
> >
> >Hi,
> > I have a table with over 100 columns that I'm trying to load.
> > When I do the load, on one of the data entries I get a message
> > from the loader that one of the columns is too long. But, it
> > doesn't tell me which one. To go thru all of the columns will
> > be rather time consuming and I suspect that I might have more than
> > one record with this problem.
> >
> > Does anyone know of an easy way to find out which entry is
> > actually in error?
> >
> > Thanks,
> > parris
 

> Are you using the log= option of the sqlloader? This will usually show the
> error.
 

> Dave Marcus
Received on Mon Nov 20 1995 - 00:00:00 CET