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

cyc73 wrote:
> Hi,
>
> Thank you for your response. I use the script your provided and to see
> if I can find any sequence in there. I only see it trigger to update
> the personnel id into table. I got two sequence names out of
> ALL_SEQUENCE table that are related to the table I want to check. I
> think I am going to do some testing in our BUILD environment to see if
> the sequence name I got is the one we are using by doing some insert
> with next available value.
>
> One question that is not related to the subject. The sequence I am
> going to test has cache of 2000, and I notice the ID using this
> sequence will jump 2000 roughly each week. What I mean is we were
> using ID range in 728000 for last week, then this week sometimes the ID
> start with number 730000. Do you know what cause the number to jump?
> Thank you.

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, like
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1119633817597 .

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=196901658