Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Q:SQL*Loader Problem with Date ORA-01861

Re: Q:SQL*Loader Problem with Date ORA-01861

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Thu, 31 Oct 2002 08:22:41 -0000
Message-ID: <3dc0e850$0$13369$cc9e4d1f@news.dial.pipex.com>


"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3DC04164.B42B2B49_at_exesolutions.com...
> Ralf Bender wrote:
>
> > Hi Daniel,
> > Well, I changed my Controlfile:
> > LOAD DATA
> > INFILE 'R8'
> > into table R8
> > fields terminated by "," optionally enclosed by '"'
> > (
> > notesdocid,
> > gpfearcid,
> > arclevel,
> > decdocid INTEGER EXTERNAL TERMINATED BY WHITESPACE,
> > doctype INTEGER EXTERNAL TERMINATED BY WHITESPACE,
> > ablagekreis,
> > mandant,
> > rechnr,
> > dokdatum DATE "YYYY-MM-DD",
> > kundennr
> > )
> >
> > ...BUT, the same Error occurs! May the quotes be a problem?

Are you absolutely sure that all of your dates in the file are of the form YYYY-MM-DD?

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Thu Oct 31 2002 - 02:22:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US