Re: how big can sequence number go?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 17 Oct 2000 19:47:08 +0100
Message-ID: <971809629.12033.0.nnrp-10.9e984b29@news.demon.co.uk>

I hadn't come across that one - the
nominal limit is the normal nominal size of a 38 digit integer.

There was a bug at one stage with parallel queries where the sequence supplying the ORA_TQ_BASE$ value had to be reset
because the PQ slave code couldn't handle ids in excess of a few million - perhaps this is the one you've heard of.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

colormouse_at_my-deja.com wrote in message <8sg8nk$gpk$1_at_nnrp1.deja.com>...


>Guys:

>

>   I heard that in Oracle 7 there is a bug so that the sequence number

>can only go up to 3 million or so. Currently we are using Oracle 8, how

>big can sequence number go? Is there any other problem with this

>sequence number?

>

>   Thanks a lot for help.

>

>Qing

>

>

>Sent via Deja.com http://www.deja.com/

>Before you buy.

Received on Tue Oct 17 2000 - 13:47:08 CDT