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

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.

Crystal

gazzag wrote:
> You don't. Sequences are not associated with tables. You *might* find
> that there's a trigger on that table that makes use of that sequence.
>
> >From a SQL*Plus prompt, try:
>
> SQL> select trigger_body from dba_triggers
> where owner='<schema_name>' and table_name='<table_name>';
>
> Also, Oracle encourages the use of sensible naming conventions so
> *hopefully* there should be a clue in the sequence's name.
>
> HTH
>
> -g
Received on Thu Jan 18 2007 - 09:58:45 CST