Re: [About Sequence] Ambigous value !!!

Try to create the SEQUENCE without cache. Now your cache value is 20, I think.

I hope it will helps you.

Jpserver2 wrote:
>
> About Sequence Object :
>
> After Oracle DB Server down and reboot,
> Current Value of Sequence Object is incorrect.
>
> For Example
> NAME : TEST
> MINIMUM : 10
> MAXIMUM : 97
> INCREMENT : 1
> OPTION : CYCLE VALUES - CHECKED
> ORDER VALUES - UNCHECKED
> CACHE : DEFAULT
>
> CURRENT VAL : 30
>
> After Rebooting, nextval is 50 !!!
>
> Please help me! Why values is this?

-- 
Valery A. Sorokin
ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 (6 lines) FAX: +7 (095) 234 0640
E-mail: vsorokin_at_dd.ru OR vsorokin_at_prosoftmpc.msk.su
http://www.dd.ru