Re: How to reset Sequence values ?

...and I bet a lot more consequences, which really have to be analyzed before one go for renaming a schema object whatsoever.

Be careful out there!

Regards, Michael

In article <981040531.9854.2.nnrp-08.9e984b29_at_news.demon.co.uk>,   "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
>
> Synonyms ?
>
> --
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> Practical Oracle 8i: Building Efficient Databases
> Publishers: Addison-Wesley
>
> Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html
>
> Brian Peasland wrote in message

 <3A796D99.63BF554C_at_edcmail.cr.usgs.gov>...
> >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.
> >
>
>

Sent via Deja.com
http://www.deja.com/ Received on Fri Feb 02 2001 - 02:12:15 CST