Re: SQL*Loader - what happened?
Date: Tue, 8 Apr 2003 12:54:07 -0400
Message-ID: <b6uueb$5eb$1_at_dns3.cae.ca>
This is an example from a control file that I actually use.
START_DATE date � DD-MM-YYYY HH24:MI:SS � ,
"Monica Roman" <monicaroman_at_yahoo.com> wrote in message
news:9eb77af5.0304080511.6b6b5aca_at_posting.google.com...
> >
> > Look for a .log file that says what all is wrong. It will say whether
> > you have bad data errors or all the constraints failed. If you don't
> > have a .log file, specify one when you run the command.
> >
> > jg
>
> Hi,
> I looked at the .log and it says that:
>
> Record 1: Rejected - Error on table TABLEX, column TBLDATE.
> ORA-01861: literal does not match format string
>
> When I created the table, I said: CREATE TABLE Tablex (
> TblDate date, ...etc);
>
> The log file said:
>
> Column Name Position Len Term Encl Datatype
> ------------------------------ ---------- ----- ---- ----
> ---------------------
> TBLDATE FIRST * , CHARACTER
> TBLPRIORITY NEXT * , CHARACTER
> etc.
>
> So I think it is trying to bring in the date as character. How do I
> make it load as a date in this format? 2003-04-07 08:59:15
>
> Thanks so much!
Received on Tue Apr 08 2003 - 18:54:07 CEST