Re: SQL* Loader problem with timestamp data

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 24 Oct 2001 22:42:51 +0200
Message-ID: <ttefsddvbtuf5d@corp.supernews.com>

"Marco Mapelli" <mapellim_at_usa.net> wrote in message news:53d76e1f.0110241106.209ae66c_at_posting.google.com...
> Hello all,
>
> I am desperately trying to load timestamp data into
> Oracle 8i Rel. 8.1.6 under Linux Red Hat 6.1.
> The timestamp field has the following format :
>
> dd-mon-yyyy hh:mi:ss
>
> example :
>
> 12-DEC-1999 12:14:54
>
> I tried to specify the field in the control file as
> both CHAR and DATE with various format with no success.
> When I take the time part of the date off I can successfully
> load into the DB.
> Any suggestion ?.
>
> Thanks in advance
>
> Marco Mapelli

Please check in the Oracle Server Utilites command you can specify a mask with the date datatype in sql*loader

Hth,

Sybrand Bakker
Senior Oracle DBA Received on Wed Oct 24 2001 - 15:42:51 CDT