Re: How to reset Sequence values ?

Michael,

Interesting... How do you propose renaming the sequence? There is no ALTER SEQUENCE RENAME command.

But if you could, then I suppose you could guarantee automicity. You could also guarantee it by starting the database in restricted mode and altering the sequence as previously suggested. But this is still a long way to go when it is much easier to just drop and recreate the sequence.

HTH,
Brian

> Hi,
>
> And thanks for the interesting input.
>
> In some cases you might be able to rename the sequence before altering
> it, and back-name it when done. This would have many consequences like
> invalidating procedures and package bodies, generate runtime errors
> etc., but it would guarantee atomicity, wouldn't it?
>
> /Michael
>
> Sent via Deja.com
> http://www.deja.com/
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================