Re: [About Sequence] Ambigous value !!!
From: Nikolay Malakhov <mal_at_kpbank.ru>
Date: Thu, 20 Aug 1998 14:45:25 +0700
Message-ID: <35DBD415.74747A7C_at_kpbank.ru>
You can use NOCACHE.
Date: Thu, 20 Aug 1998 14:45:25 +0700
Message-ID: <35DBD415.74747A7C_at_kpbank.ru>
Jpserver2 wrote:
> After Oracle DB Server down and reboot,
> Current Value of Sequence Object is incorrect.
>
> CURRENT VAL : 30
>
> After Rebooting, nextval is 50 !!!
> CACHE : DEFAULT
^^^ This is the point!Default cache size = 20
You can use NOCACHE.
Hope this help.
Nikolay Malakhov
KuzbassPromBank
Received on Thu Aug 20 1998 - 09:45:25 CEST