Re: sqlldr problem (invalid number)
Date: Thu, 27 Feb 2003 08:18:16 GMT
Message-ID: <cRj7a.328140$AA2.12294333_at_news2.tin.it>
That's the best option, performance will increase as well because you don't need to perform any data manipulation while loading the table and SQL*Loader will interpret the number correctly always.
Bye,
Flavio
"Guido Buerger" <guido.buerger_at_gmx.de> wrote in message
news:10eb3a31.0302270007.7b46679a_at_posting.google.com...
> "FC" <flavio_at_tin.it> wrote in message
news:<NN57a.238429$0v.6669387_at_news1.tin.it>...
> > Which version of Oracle Guido ?
> > ...
> > If you could change the format of the file and put the minus sign in the
> > right place, that would be the best solution.
>
> Hi, Flavio!
>
> I'm using Oracle 8.1.7. It really seems so that I have to manipulte
> the input file before read in by the sqlldr. This ist not a problem
> for me, but I thought I can avoid this step by a clever control file.
>
> Thanks for you help,
> Guido
Received on Thu Feb 27 2003 - 09:18:16 CET