Re: SQLLDR
From: S. Anthony Sequeira <nobody_at_127.0.0.1>
Date: Fri, 21 May 2010 15:40:06 +0100
Message-ID: <ht660k$kmr$1_at_news.eternal-september.org>
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.
Date: Fri, 21 May 2010 15:40:06 +0100
Message-ID: <ht660k$kmr$1_at_news.eternal-september.org>
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