Re: SQL* Loader problem with timestamp data

mark.powell_at_eds.com (Mark D Powell) wrote in message news:<178d2795.0110250504.13a5caa_at_posting.google.com>...
> "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.
>
> -- Mark D Powell --

I changes the date mask as suggested by Sybrand to DD-MON-YYYY HH24:MI:SS in control file and I finally succedded.

Thanks again and regards

Marco Mapelli Received on Sun Oct 28 2001 - 14:15:47 CST