Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: How to reset Sequence values ?

Re: How to reset Sequence values ?

From: <mohammad_amer_at_my-deja.com>
Date: Tue, 30 Jan 2001 08:57:13 GMT
Message-ID: <955vl7$j68$1@nnrp1.deja.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US