Re: Help ! - How to resync sequence numbers to a table (Oracle)

> I might be a bit late to the party here, but have a look at changing
the
> increment of the sequence from 1 to some huge number that takes you

> over the MAX() value in the table. Extract the nextval from it and
reset
> the increment to 1 again.
>
> Something similar to
>
> http://www.jlcomp.demon.co.uk/faq/resetseq.html
>
>
> Cheers,
> Norm.

That is, option 3 above. Received on Sun Feb 20 2005 - 17:05:06 CST