Re: Sequences: where do 'unused' numbers go in case of rollback
From: Steve Edelstein <74160.645_at_CompuServe.COM>
Date: 1995/10/03
Message-ID: <44rffv$rgh$2_at_mhadg.production.compuserve.com>#1/1
Date: 1995/10/03
Message-ID: <44rffv$rgh$2_at_mhadg.production.compuserve.com>#1/1
Numbers not used in a rollback are lost. The only way to reuse
the number(s) is to drop and recreate the sequence, as in
drop sequence x;
create sequence x start with 123; (or the number you need)
Otherwise there will be holes in the sequence.
STEVE
-- Steve Edelstein VOICE: 212-956-3670 Relational Business Systems CompuServe: 74160,645 124 West 60th Street Suite 47C Author of New York, NY 10023 "Learning Oracle Forms"Received on Tue Oct 03 1995 - 00:00:00 CET