Re: SQL Loader and TRAILING NULLS error

I seem to remember that TRAILING NULLS occurs when the incoming data contains fewer columns than the control file - or is it the table itself - specifies. (Duh. "Trailing" nulls?) So you could load 20 tables just fine; what does that have to do with the other 4? (That probably sounds more sarcastic than it is.) I also seem to remember that there is a sqlldr option that deals with trailing nulls - actually inserts a null into the subject column, or doesn't try to insert to that column at all. Sorry for the poor memory.

As to rewriting something that worked in 7, I don't think sqlldr has been rewritten since Oracle 4!

• Mike Scott A. Haas <sahaas_at_lazerlink.com> wrote in message news:38A8D475.7C7F46E3_at_lazerlink.com...
  > What database are you using ? Oracle 8 ... Oracle 7 ...
  > I know we've seen problems with the Oracle 8.0.5.0.1 SQL*Loader.
  > Probably even this
  > TRAILING NULL error. You could try to run the sqlload with the data in
  > the file,
  > instead of an external file.
  > Oracle is preparing a patch for 8.0.5.1.0 to fix problems with SQL
  > Loader.
  >
  > This may give you all a chuckle ... When we first called in a problem
  > with SQL Loader, the person said, "Well that's the way it work's now."
  > It seems Oracle decided to rewrite its sqlload utility.... Why try to
  > change something that worked great in Oracle 7 ?
  >
  > tigger wrote:
  > >
  > > I keep getting a TRAILING NULL error on my load. I have successfully
  > > imported 20 tables and the 4 remaining tables have this error. The
  > > controls files have been reviewed and look fine.
  > >
  > > Has anyone ever heard of that error - can not find anywhere!
  > >
  > > T