Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Direct path sqlldr and implied decimals problem
Paul McGettigan wrote:
>
> I am having a problem reading in implied decimals using direct path sqlldr
>
> I have numeric data coming accross in the format
> 1234567890-
> 0000012345+
> 0000002222-
>
> I have tried to read the data in using the zoned decimal format and while it
> successfully adds the rows it is ignoring the signs.
> All rows are loaded as positive numbers.
>
> The fields in the table have been declared as
>
> test_amt number(10,2)
>
> The sqlldr control file is reading the data as
>
> test_amt position(1:11) zoned(10,2)
>
> Using the conventional path sqlldr is possible I know - but due to the size of
> the datafiles (1GB) is impractical.
>
> Has anyone got any suggestions?
>
> Thanks
> Paul
Since numeric data can have trailing or leading signs you might
give sqlldr and hint where the sign is. If there is no negative
numbers in your data you can ignore the sign.
luck. Received on Thu Jun 04 1998 - 20:48:58 CDT