Re: Sequences

From: Igor Espiau <espiaui_at_logica.com>
Date: Fri, 5 Feb 1999 14:35:56 -0000
Message-ID: <79evkf$2ap@romeo.logica.co.uk>

No I have already check that.
The difference is greater than 20.

Thanks for your input

Igor
Em Pradhan wrote in message <36BA1110.D5C14A77_at_dplus.net>...
>Hi
> If I am not mistaken
> when we create the sequence the default cache value for
>sequence is
>20 and when we shutdown the database there may be a chance of losing 20
>sequence numbers at worst. So, I am just guessing this is what happened
>to your system...
>
>Hope this help.. good luck.
>
>pradhan
>
>Igor Espiau wrote:
>
>> Hi all,
>>
>> I had to change the size of some tables and tablespaces in a
>> production Oracle 7.3 db so I exported the data, made the mods and then
>> re-imported the data again.
>> Now my application does not work because the sequences have not
>> the right NEXTVAL. I suppose I now need to drop and recreate the
sequences,
>> but , what did I do wrong in the first place????
>>
>> Thanks to all
>>
>> Igor
>
>
>
Received on Fri Feb 05 1999 - 08:35:56 CST