Oracle How to reset Sequence without dropping it

In this article, we will learn how to reset Sequence to a particular value without dropping it. Let's suppose the current value of the sequence e.g seq_person_id is 10234 and we want to reset it to 100.

Step 1

alter sequence seq_person_id increment by -10134 minvalue 0

Note: MINUS sign with 10134.

Step 2

select seq_person_id.nextval from dual

Step 3

alter sequence seq_person_id increment by 1 minvalue 0;

The sequence is now reset to 100.