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

Home -> Community -> Usenet -> c.d.o.misc -> Re: sequence count not correct

Re: sequence count not correct

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Thu, 15 Jul 1999 13:49:31 -0400
Message-ID: <7ml6u4$ne4$1@autumn.news.rcn.net>


Hi Steffi,

    When you create the sequence you can specify the cache value. Since you can also set sequence values this is a change you can make on the fly. drop the existing sequence and then recreate it with the values you want to use.

regards
Jerry Gitomer

Steffi wrote in message <378DE10E.B80046AA_at_planet.de>...
>thanx for your help
>
>can I manual adjust this sequence? or it it better to use a number and
>count +1?
>
>
>Paul J S Green schrieb:
>>
>> Sequence has a cache value if i recall (default 20). This is flushed
when
>> DB is bounced.
Received on Thu Jul 15 1999 - 12:49:31 CDT

Original text of this message

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