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

From: Frank <fvanbortel_at_netscape.net>
Date: Wed, 27 Nov 2002 21:53:12 +0100
Message-ID: <3DE530B8.9090606@netscape.net>

Niall Litchfield wrote:
> "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
> ******************************************
>

You have to specify the length of the date field... Yes, you do - a glimpse in the Utilities manual would have explained that - it's in one of the examples. In your case, try DATE(10) instead of DATE.

Grtz Frank Received on Wed Nov 27 2002 - 14:53:12 CST