Alter snapshot log failure

From: Mark Janveaux <mark_at_trakware.com>
Date: 1999/08/25
Message-ID: <SFWw3.88$G6.10236_at_news0.telusplanet.net>#1/1

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 - 00:00:00 CEST

This message: [ Message body ]
Next message: Michael Buresch: "SQL*Worksheet login and run script aut."
Previous message: G.P. Singh: "Re: ROLLBACK tablespace needs media recovery when startup mount;"
Next in thread: Michel Cadot: "Re: Alter snapshot log failure"
Reply: Michel Cadot: "Re: Alter snapshot log failure"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message