Re: How can I alter sequence ?

Bts Rosy wrote:
>
> 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?

   alter sequence seq increment -19;

   select seq.nextval from dual;

   alter sequence seq increment 1;

Valery Yourinsky

-- 
Oracle8 Certified DBA
Moscow, Russia