Re: sqlldr problem with datetime fields

[Quoted] You are right .. this baby fails in 8.1.7

I guess the error message threw us off. I was on the track that in some twisted version of Oracle the lastmodified name is reserved word or something.

The problem is the TIMESTAMP specification. Why? I don't know as yet .. and am in a hurry. My guess is that TIMESTAMP is a valid ctl file specification for 9i .. but not for 8i.

So here is what you should try in your ctl file:  load data
infile 'image_pp.txt'
into table image_pp
fields terminated by ';' optionally enclosed by '"' (IMAGEID integer external,
 ELEMENTNAME char,
 OVERRIDEPATH char,
 CREATED DATE "YYYY-MM-DD HH24:MI:SS",
 LASTMODIFIED DATE "YYYY-MM-DD HH24:MI:SS",  LASTUSER integer external
)

I replaced TIMESTAMP with DATE ... things loaded fine then

Anurag

"Jim Flynn" <jflynn_at_engage.com> wrote in message news:9747aacb.0208071346.24894a45_at_posting.google.com...
> "Anurag" <avdbi_at_hotmail.com> wrote in message news:<ul14946jvp16b7_at_corp.supernews.com>...
> > I did test your scripts on a 9.2 version Oracle and it ran fine.
> > I can check on 8.16 and 8.1.7 versions also .. but frankly I don't expect
> > sqlldr to fail this load in any of these versions.
> > Please state your Oracle version and state what command line parameters
> > you are passing to sqlldr.
> >
> > Anurag
>
> Anurag,
>
> I am running 8.1.7. I am using this command line (about as simple as you can get!)
>
> sqlldr control=image_pp.ctl
>
> I then enter username and password.
>
> Thanks for the effort!!
Received on Thu Aug 08 2002 - 01:04:47 CEST