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 -> How to reset Sequence values ?

How to reset Sequence values ?

From: hunter <fmarchioni_at_libero.it>
Date: Thu, 25 Jan 2001 11:36:21 +0100
Message-ID: <94ouvh$jrr$1@marte.lastminutetour.com> 






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
Received on Thu Jan 25 2001 - 04:36:21 CST












Original text of this message













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