Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: HELP ! : sequence nextval
Brian wrote:
>
> But can't i just set the value without deleting & recreating?
No, but check out this link at AskTom.oracle.com http://asktom.oracle.com/pls/ask/f?p=4950:8:56728802570671107::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1119633817597,
(link probably wrapped)
it explains resetting the value (to a certain degree anyways) by playing with the "increment by" value.
hth
Bricklen Received on Thu Apr 17 2003 - 11:34:58 CDT