Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: How to reset Sequence values ?
In article <3A70187B.2F9AEF75_at_ougf.fi>,
Kari Pannila <Xkartsa_at_ougf.fi> wrote:
>
>
> 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.
>
>
why kari does he have to re-create the sequences?
he can alter them..
Sent via Deja.com
http://www.deja.com/
Received on Tue Jan 30 2001 - 02:57:13 CST