Re: SQLLDR

From: S. Anthony Sequeira <nobody_at_127.0.0.1>
Date: Fri, 21 May 2010 16:26:51 +0100
Message-ID: <ht68nq$91c$1_at_news.eternal-september.org>



On 21/05/10 16:03, The Magnet wrote:
> On May 21, 9:40 am, "S. Anthony Sequeira"<nob..._at_127.0.0.1> wrote:
>> 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
>>

[...]
>
> Whatever, strange, weird. I removed the decimal percition on the
> numeric columns, and wham, everything loaded. Go figure.
>

Cool.

-- 
S. Anthony Sequeira
++
Don't look now, but there is a multi-legged creature on your shoulder.
++
Received on Fri May 21 2010 - 10:26:51 CDT

Original text of this message