Re: How to reset Sequence values ?

Hey;

SQL> select sequence_name, last_number
  2 from user_sequences;

SEQUENCE_NAME                  LAST_NUMBER


------------------------------ -----------

HRS                                     22
KEYS                                    90

SQL> update user_sequences
  2 set last_number = 1
  3 where sequence_name = 'KEYS';

1 row updated.

SQL> select sequence_name, last_number
  2 from user_sequences;

SEQUENCE_NAME                  LAST_NUMBER


------------------------------ -----------

HRS                                     22
KEYS                                     1

I then created a table and used the sequence; seemed to work. Am I missing something?

Doug

-- 
-------------------
Douglas K. O'Leary
Senior System Admin
dkoleary_at_mediaone.net