Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Alter snapshot log failure
I make some test, it seems to me that's a bug.
As a matter of fact, FLOAT means FLOAT(126) with
binary precision that is 38 decimal digits but it
seems that alter snapshot log takes the binary
precision for the decimal precision:
if you try with FLOAT(38) that's work but if you take
FLOAT(39) there is an error on alter snapshot log.
As a work around, you can execute the statements: alter table TPROCESS modify DEFAULT_MARKUP_PCT number; alter snapshot log on TW.TPROCESS add (DEFAULT_MARKUP_PCT); alter table TPROCESS modify DEFAULT_MARKUP_PCT float;
That works, i tried it.
Regards.
Mark Janveaux a écrit dans le message ...
>I'm trying to execute the following :
>
>alter snapshot log on TW.TPROCESS
>add (
>DEFAULT_MARKUP_PCT)
>
>I then get a error message :
>
>ERROR at line 1:
>ORA-01727: numeric precision specifier is out of range (1 to 38)
>
>The column I'm adding is of the FLOAT datatype and it's precision is set at
>22 ( the default ). How come I'm getting an error of this sort ?
>Any help on the above would be appreciated. Thank you for reading this.
> Mark Janveaux
> Trakware Systems Inc.
>
>
>
>
Received on Mon Aug 30 1999 - 04:56:44 CDT