Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Changing the Current Value of a Sequence?
Is there any way to reset the current value of a sequence to a different number, other than by dropping and recreating the sequence? I know it can't be done using ALTER SEQUENCE. The only thing I can come up with is to keep selecting NEXTVAL until I get to the desired value, but that seems tedious. Any other ideas? Received on Fri Jan 16 1998 - 00:00:00 CST