"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:<ttefsddvbtuf5d_at_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
Marco, please post the sqlldr control statements along with one line
of data so that we can see what you are doing and perhaps someone will
spot the problem and point it out.
Received on Thu Oct 25 2001 - 08:04:38 CDT
