Re: about sequence in oracle

From: Honza Pazdziora <adelton_at_fi.muni.cz>
Date: Wed, 22 Aug 2001 11:58:22 GMT
Message-ID: <slrn9o77is.6o22.adelton@nemesis.fi.muni.cz>

On 14 Aug 2001 09:21:56 -0700, David Fitzjarrell <oratune_at_msn.com> wrote:

> there is no such ALTER SEQUENCE ... START WITH ... option. And, for
> large discrepancies [starting value of 1, current value 15687] it is
> far easier to drop and recreate the sequence with the proper starting
> value than it would be to run through 15686 iterations with a negative
> increment.

Just do one iteration with increment -15686.

-- 
------------------------------------------------------------------------
 Honza Pazdziora | adelton@fi.muni.cz | http://www.fi.muni.cz/~adelton/
 .project: Perl, mod_perl, DBI, Oracle, auth. WWW servers, XML/XSL, ...
Petition for a Software Patent Free Europe http://petition.eurolinux.org
------------------------------------------------------------------------

Received on Wed Aug 22 2001 - 06:58:22 CDT