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 -> Re: Question about Sequences

Re: Question about Sequences

From: RSH <RSH_Oracle_at_worldnet.att.net>
Date: Wed, 05 Jun 2002 20:57:25 GMT
Message-ID: <VWuL8.22998$LC3.1722629@bgtnsc04-news.ops.worldnet.att.net>


Yeah,

START is all I could think of as well.

Yech, that's a bit of a mess.

RSH.
"Ryan Gaffuri" <rgaffuri_at_cox.net> wrote in message news:1efdad5b.0206050710.4af26dd4_at_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 - 15:57:25 CDT

Original text of this message

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