From: mhr123@my-deja.com
Newsgroups: comp.databases.oracle.misc
Subject: Re: How to reset Sequence values ?
Date: Fri, 02 Feb 2001 08:12:15 GMT
Organization: Deja.com
Lines: 42
Message-ID: <95dq4s$d42$1@nnrp1.deja.com>
References: <94ouvh$jrr$1@marte.lastminutetour.com> <94pbtp$cbu$1@nnrp1.deja.com> <3A71881D.2F0A1BC1@edcmail.cr.usgs.gov> <95bc9t$8f1$1@nnrp1.deja.com> <3A796D99.63BF554C@edcmail.cr.usgs.gov> <981040531.9854.2.nnrp-08.9e984b29@news.demon.co.uk>
NNTP-Posting-Host: 195.249.17.6
X-Article-Creation-Date: Fri Feb 02 08:12:15 2001 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT)
X-Http-Proxy: 1.0 VIRUSWALL, 1.0 x65.deja.com:80 (Squid/1.1.22) for client 195.249.17.6
X-MyDeja-Info: XMYDJUIDmhr123


...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@news.demon.co.uk>,
  "Jonathan Lewis" <jonathan@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@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/