Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Re: Auto sequencing
Upon further reading of Shaun's question, the
simple answer is:
Yes, set the sequence generater to max(USERID)+1
Either (a) recreate the sequence using START WITH n
or (b) change the INCREMENT BY, do a nextval to bump it up
a large number, then change the INCREMENT BY back to 1
(3 steps)....
(Anyone know other ways to change a sequence?)
Robert Proffitt
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Apr 19 2000 - 00:00:00 CDT