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

Home -> Community -> Usenet -> c.d.o.server -> Question about Sequences

Question about Sequences

From: Ryan Gaffuri <rgaffuri_at_cox.net>
Date: 5 Jun 2002 08:10:33 -0700
Message-ID: <1efdad5b.0206050710.4af26dd4@posting.google.com>


Someone on my project recently truncated all the tables in one of our databases and imported new data. The problem is that the our sequence generators did not reset to match the highest sequence we have in our primary keys, so we keep hitting a unique constraint.

Is there a command to reset sequences to the highest value in the table?
Id prefer to run this dynamically than have to find the highest value for each sequence add set it to n + 1. This would be time consuming.

Thanks. Received on Wed Jun 05 2002 - 10:10:33 CDT

Original text of this message

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