Path: news.easynews.com!easynews!sn-xit-02!sn-xit-06!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: "Anurag" Newsgroups: comp.databases.oracle.tools Subject: Re: sqlldr problem with datetime fields Date: Wed, 7 Aug 2002 19:04:47 -0400 Organization: Posted via Supernews, http://www.supernews.com Message-ID: References: <9747aacb.0208051048.2e2f12a2@posting.google.com> <9747aacb.0208071346.24894a45@posting.google.com> X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Complaints-To: newsabuse@supernews.com Lines: 50 Xref: easynews comp.databases.oracle.tools:52895 X-Received-Date: Wed, 07 Aug 2002 16:02:29 MST (news.easynews.com) 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" wrote in message news:9747aacb.0208071346.24894a45@posting.google.com... > "Anurag" wrote in message news:... > > 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!!