Re: Help with SQL-Loader and date field.
Date: 1997/11/10
Message-ID: <346723C8.7B09_at_imn.nl>#1/1
Chad M. Hegerty wrote:
>
> We are having to transfer some data from a non-Oracle database into one of our Oracle databases. I am having trouble with records which contain
date fields and getting them loaded into Oracle.
> The data records look like the following:
85 84 18-jan-1989 16:27:21 28
85 88 18-jan-1989 16:39:29 28
85 89 18-jan-1989 16:39:29
28
> --
> Chad M. Hegerty (chad.hegerty_at_rossnutrition.com)
> Ross Products Division - Abbott Laboratories
Chad,
I think your problem (if you still have it that is) is the space
between "18-jan-1989" and "16:27:21"...
TERMINATED BY WHITESPACE makes SQL-Loader terminate after the
"18-jan-1989"
There should be two solutions:
Change "18-jan-1989 16:27:21" into something like "18-jan-1989:16:27:21"
or use absolute positioning :-)
Good luck,
Jef Jakobs (j.jakobs_at_imn.nl) Received on Mon Nov 10 1997 - 00:00:00 CET