Re: How to know what sequence a table is using?

cyc73 wrote:
> On Jan 18, 6:38 pm, "joel garry" <joel-ga..._at_home.com> wrote:
> Do you bounce the db? This will reset to the next 2000 because of the
> > caching. You can write code to make the current sequence whatever you
> > want, if necessary, likehttp://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1...
> > .
> >
> > Welcome to the group! Here's a readme about it:http://www.dbaoracle.net/readme-cdos.htm
> >
> > jg
> > --
> > @home.com is bogus.
> > Arrrrgh!http://www.informationweek.com/windows/showArticle.jhtml?articleID=19...
>
> After checking with this documentation, I think I am going to drop the
> sequence and recreate it. This will allow me to set the starting
> number, which is what we need to do. We will still keep the cache for
> 2000 because that's how it used to be. Thank you.
>
> Crystal

Why do you need to reset the starting number? If for some test purposes or a one-time fix to a production problem (probably INCREASING the starting number) I can understand. But from your comments, I'm suspecting you're planning on doing this on a regular basis. One thing you need to understand about sequences is they only guarentee uniqueness and sequence. They do NOT guarentee an unbroken chain of numbers. If you think you *need* an unbroken, contiguous chain of numbers, then I'd suggest you really think through why you think you need it. This is often just assumed with no real world business justification. Received on Fri Jan 19 2007 - 11:28:37 CST