Re: How to reset Sequence values ?

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/