How can i change my sequence's so that attribute "NextVal" would return me now value 1'000'000? It is resetting of current value of the sequence. Can it be done.
I don't see such possibility from there:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_2011.htm
I tried un-successfully that sentence:
ALTER SEQUENCE Casino.Networkplayers_Code_Seq minvalue 1000000000--ORA-04007: MINVALUE cannot be made to exeed the current value
Or should i do arithmetics like is done there:
http://www.lifeaftercoffee.com/2005/10/20/changing-the-current-value-of-oracle-sequences/
Edited by: CharlesRoos on 29.10.2010 16:46