Re: Losing sequence numbers

If you're caching numbers (using the parameter to the CREATE SEQUENCE SQL statement) then you'd lose numbers whenever the SGA is rebuilt (when you shutdown and startup the db). In that case any unused numbers are lost and not replaced. Caching ensures that requests for sequence numbers are dealt with from the SGA rather than going back to the db for a new one, but you've found the problem in caching: there may be holes in the primary key sequence. The solution is, I guess, to accept the missing numbers or stop caching.

HTH

-- 
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"