Re: How to reset Sequence values ?

hunter 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

Hi

You should recreate the sequences.

regards Kari

(Mr.) Kari Pannila

      Oracle DBA (OCP)

--

PS. Delete X from my mail address , it (X) is only for SPAMMERS.
    Poista X mail-osoitteen edestä, se on SPAMmereita varten.