Re: How to reset Sequence values ?

From: hunter <fmarchioni_at_libero.it>
Date: Thu, 25 Jan 2001 14:00:19 +0100
Message-ID: <94p7de$sg6$1@marte.lastminutetour.com>

Thanks- the best solution is often the easier.......Ok. thanks again
bye

<sybrandb_at_my-deja.com> wrote in message 94p5m2$74q$1_at_nnrp1.deja.com...
> In article <94ouvh$jrr$1_at_marte.lastminutetour.com>,
> "hunter" <fmarchioni_at_libero.it> wrote:
> > Hello!
> > I have built some tables where primary keys are incremented via
> > Sequence values.I put some dummy values to test the software
> > but now I have to clean tables for real use of the software.
> > The matter is that sequence values still keep count of their
> > values even if I deleted all records.....how can I remedy it?
> > is it possible to reset sequence count?
> > Thanks
> > Francesco
> >
> >
> AFAIK the only way is drop the sequence and recreate. Of course the
> sequence keeps the current value, as sequence are not bound to any
> object.
>
> Hth,
>
> --
> Sybrand Bakker, Oracle DBA
>
> All standard disclaimers apply
> ------------------------------------------------------------------------
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Thu Jan 25 2001 - 07:00:19 CST