Re: Help with SQL-Loader and date field.

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