Re: RESETTING A SEQUENCE

From: Andrew Pahomov <Pahomov_at_validio.com.ua>
Date: Mon, 27 Nov 2000 04:38:17 +0200
Message-ID: <3a22713f$1@miik2-ilt.ilt.kharkov.ua>

Or create sequence with cycle and writing simple script for cycle sequence until right value not find ;)

Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message news:8vtlq4$5qnut$2_at_ID-62141.news.dfncis.de...
>
> "SDG" <simong_at_explor.co.uk> wrote in message
> news:7psU5.276$4o3.168024_at_newsr1.u-net.net...
> > HOW DO YOU RESET A SEQUENCE NUMBER ?
> >
> > Thanks in anticipation
> > SDG
> >
> >
> First of all: please stop using caps.
> You can reset a sequence by dropping and recreating it, alter sequence
will
> not work.
>
> Hth,
> Sybrand Bakker, Oracle DBA
>
>
>
Received on Sun Nov 26 2000 - 20:38:17 CST