Re: SQLLDR

From: The Magnet <art_at_unsu.com>
Date: Fri, 21 May 2010 08:03:31 -0700 (PDT)
Message-ID: <aa7fca2f-9755-4ec9-a320-b637a4c78e9b_at_b21g2000vbh.googlegroups.com>



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
>
> --
> S. Anthony Sequeira
> ++
> Q:      What is purple and commutes?
> A:      An Abelian grape.
> ++

Whatever, strange, weird. I removed the decimal percition on the numeric columns, and wham, everything loaded. Go figure. Received on Fri May 21 2010 - 10:03:31 CDT

Original text of this message