Change sequence without dropping

This manual describes how to adjust the value of a sequence without dropping it. The solution is to set the INCREMENT BY value to the difference between the current value and set the value required. Then you have to use this value once and then switch back to INCREMENT BY = 1


The TR_TAB trigger depends on SQ_TAB_A sequence.

Start with valid  trigger.

Now drop the trigger.

As expected the trigger becomes invalid.

Another way to avoid that is to be INVALID triggers the INCREMENT BY to pass. Value to

We assume that the current value is 300, we want that the new value is 500, so the difference is 200.

The trigger is  VALID

Please let me know if this manual ‘change sequence without dropping’ was usefull to you. If there are  errors or you have suggestions regarding this manual, please let me know.
No rights can be derived from this manual



Maarten Schoonus

Leave a Reply