Trigger goes only to 1000 and Stops

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:32:59 CST