Sequence Help

[puneet]

How to find out in a database what sequences are reaching their max value . I need to increase the max_value of these because if they cycle their I will have a unique constraint problem

Thanks

[slimdave]

select from the dba_sequences, all_sequences, or user_sequences view.

[sambavan]

Use the dba_sequence/user_sequences view to check this

   View the sequences that are 100 counts short of reaching the max value.

   SELECT sequence_name,
          sequence_owner,
          last_number,
          max_value 
     FROM dba_sequences
    WHERE last_number > (max_value-100);

Sam

[puneet]

How do I compare the CURVAL to max_value for all these sequences ..

[sambavan]

The last number is your CURVAL

Sam

[puneet]

Thanks

You are always a Great help !

[TomazZ]

alter sequence sequence_name nocycle?