Re: Trigger goes only to 1000 and Stops

From: damorgan <damorgan_at_exesolutions.com>
Date: Fri, 15 Mar 2002 16:35:20 GMT
Message-ID: <3C9222CB.2924CEB9@exesolutions.com>

Sounds like the sequence is cycling. Check it out by running 1500 selects into a dummy table with no constraints.

If so you will need to rebuild the sequence.

Daniel Morgan

Arash wrote:

> Hi!
> I have a Problem with a Trigger in ORACLE8i.
> I have a table with a Trigger creating the ID.
> The Trigger is increasing a Sequence, that has MINVALUE 1, MAXVALUE 1.0E27
> and STEPVALUE 1.
>
> Now, since the Sequence reached the value 1000, I get an
>
> ORA-00001: unique constraint (INTRANETUSER.PK_IDUSER) violated
>
> every time I try to INSERT new Data through an ASP-Script.
>
> Anyone knows what that is all about?
> thanx, Arash.
Received on Fri Mar 15 2002 - 10:35:20 CST