Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.vmunix.org!uio.no!news.tele.dk!news.tele.dk!small.news.tele.dk!newsrouter-eu.astraweb.com!news.astraweb.com!router1.astraweb.com!sn-xt-sjc-15!sn-xt-sjc-07!sn-post-01!supernews.com!corp.supernews.com!news.victoria.tc.ca!vtn1!yf110
From: yf110@vtn1.victoria.tc.ca (Malcolm Dew-Jones)
Newsgroups: comp.databases.oracle.misc
Subject: Re: Rolling back sequences?
Date: 3 Apr 2006 22:38:13 -0800
Organization: Victoria Telecommunity Network
Message-ID: <44320645$1@news.victoria.tc.ca>
References: <1144120539.296116.250100@e56g2000cwe.googlegroups.com> <1144121643.525740.309030@v46g2000cwv.googlegroups.com>
X-Newsreader: TIN [version 1.2 PL2]
X-Original-NNTP-Posting-Host: 199.60.222.3
X-Original-Trace: 3 Apr 2006 22:38:13 -0800, 199.60.222.3
XPident: yf110
X-Complaints-To: abuse@supernews.com
Lines: 15
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:126367

Herod (herodt@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.