Re: sql*loader using db2 exported file

From: <pollachi_at_my-deja.com>
Date: Tue, 19 Oct 1999 14:48:44 GMT
Message-ID: <7ui0c7$cvt$1@nnrp1.deja.com>

In article <7uhlvo$5ht$1_at_nnrp1.deja.com>, raju_pillai_at_yahoo.com wrote:
> Folks, I am trying to load a db2 exported file into Oracle database.
> I am having trouble with loading a timestamp field into a data field
in
> oracle. It looks like that Oracle does'nt understand the timestamp
> field. I treid giving date(26) "yyyy-mm-dd-hh-mm-ss-tttttt" in the
> control file and still it does'nt like it.
>
> How do it load a timestamp field into oracle date field ? Please help
>
> Thanks in advance
>
> Raju
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

First of all, Oracle's date format supports only down to seconds. and also the notation for minute is "MI" not "MM". Now, if you would like to load the timestamp, in your control file, you should give the date format as : "YYYY-MM-DD-HH24-MI-SS-%%%%%%" (Assuming you are loading time in 24 hour format) This will ignore the extra digits to the right of the seconds field.

HTH Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 19 1999 - 09:48:44 CDT