Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sequences
Igor Espiau wrote:
>
> 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
> >
> >
> >
Are you sure the sequences were not dropped and recreated ? --