There's a tip on my site for doing what you ask (there's potentially a bit
more to it than just altering it to increment by -19 as someone has posted
here). And the suggestion I've read in another reply here that you have to
drop it and re-create it is just plain daft.
Regards
HJR
--
Resources for OracleT: www.geocities.com/howardjr2000
=========================================
"Bts Rosy" <b_t_s_at_263.net> wrote in message
news:005e624aaf4e0f68fcf5eea92be730cb.33476_at_mygate.mailgate.org...
> After I user sequence.nextval,the sequence.curval now is 20.
> But I want reset the curval,I hope sequence.curval=1,what I should do?
> Thanks!
>
>
> --
> Posted from [61.135.36.1]
> via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Tue Oct 16 2001 - 15:03:52 CDT
