Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Q:SQL*Loader Problem with Date ORA-01861
"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