Re: Sequences

From: Em Pradhan <empradhan_at_dplus.net>
Date: Thu, 04 Feb 1999 16:28:48 -0500
Message-ID: <36BA1110.D5C14A77@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 Thu Feb 04 1999 - 15:28:48 CST