Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Sequence Number Loss
Hi, Everyone,
I have a problem with Oracle Sequence number:
Enviroment: Oracle 8 in Sun E3000 server with Solaries2.6. Problem: When Oracle is shutdown ( "shutdowm immediate")
for a cold backup, Oracle sequences seem lose some number( advace some number), sometimes OK, and other times very bad. Our users are not happy about some numeric sequence numbers( like account#) because they are not consecutive. Suggestions sought: we want to use Sequence as our primary key source because they are guranteed to be unique and have good perfomance, but we also want the number to be consecutive( at least most of the time). Any suggestions and advices are highly appreciated.
from: Sean Zhang
<zhang_at_visi.net>
Received on Thu Jan 07 1999 - 20:18:43 CST
![]() |
![]() |