Resetting a SEQUENCE?

We have a sequence on our Oracle 8i database which is working perfectly as:

CREATE SEQUENCE ADV_SEQ START WITH 1 INCREMENT BY 1 MINVALUE 1 CACHE 20 NOCYCLE NOORDER ; Our problem is a dodgy program which has been selecting from the sequence unnecessarily, so using up thousands of sequence values which were never actually used as the primary key in the table. As a result of this, our users are unhappy about the imminent progression to a seven digit id number rather than the standard six digit one.

Does anyone know if it's possible to alter the sequence to reset it back to the original START WITH value and select the next value which NOT EXISTS in the table in question?

e.g. if a listing of the primary key from the table looks like this: 1
2
3
6
7
9
Can i get the sequence to provide me with a next value of 4, then 5, then 8, etc? Received on Tue May 06 2003 - 18:14:09 CEST