From: S. Anthony Sequeira <nobody_at_127.0.0.1>
Date: Fri, 21 May 2010 15:40:06 +0100
Message-ID: <ht660k$kmr$>

On 21/05/10 15:35, The Magnet wrote:
> This one has me going nuts. We are using SQLLDR to load a data file.
> Certain records are getting kicked with an ORA-01438 (value larger
> than specified precision allowed for this column)
> Problem the column is a DATE: price_date date "MM/DD/YYYY",
> How do you get a precision with a date column?? The format is
> correct: 05/03/2010.
> It's a lot of data, so unless someone wants to see it, I will not post
> the record(s) and control file. But again, strange error for a date
> column. And, the fields/columns match up fine.

The controlfile would be useful + (at least some of) the bad file, and relevant logfile snippets. Also the sql*loader command line used.

Also your NLS settings on server and client

S. Anthony Sequeira
Q:	What is purple and commutes?
A:	An Abelian grape.
Received on Fri May 21 2010 - 09:40:06 CDT

Original text of this message