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.
Blog about programming