Re: How to reset Sequence values ?

In article <3A796D99.63BF554C_at_edcmail.cr.usgs.gov>,   Brian Peasland <peasland_at_edcmail.cr.usgs.gov> wrote:
> 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!
> ========================================
>

Hi again,

Not to go on discussing...

The sequence is renamed with:
rename sequence whatsoever to anothername;

Regards, Michael

Sent via Deja.com
http://www.deja.com/ Received on Thu Feb 01 2001 - 09:23:02 CST