Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Alter snapshot log failure

Alter snapshot log failure

From: Mark Janveaux <mark_at_trakware.com>
Date: Wed, 25 Aug 1999 18:33:22 GMT
Message-ID: <SFWw3.88$G6.10236@news0.telusplanet.net>


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 Wed Aug 25 1999 - 13:33:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US