Re: Rolling back sequences?

From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 3 Apr 2006 22:38:13 -0800
Message-ID: <44320645$1@news.victoria.tc.ca>

Herod (herodt_at_gmail.com) wrote:
: No, you can't rollback a sequence once it is triggered.

: The following is NOT recommended:
: You can have "do it yourself sequences", have a table, in it keep a
: number, max+1 the number, update the table, it fails, it rolls back.
: But this is very very bad and really will cause nothing but problems in
: the future.

: I can scarcely believe I am suggesting it.

: http://yaodba.blogspot.com

You can drop and recreate the sequence and set the initial value to a predefined value. Perhaps that would help. Received on Tue Apr 04 2006 - 01:38:13 CDT