You can't rely on there being no gaps. Some system crashes will loose the values in cache. Picking up some NEXVAL's and then Rolling Back the transaction will make a gap too. If you want a heated opinion on this, search on "Ask Tom".
|
Results 1 to 4 of 4
Thread: sequence number was skippedThreaded View
|
Click Here to Expand Forum to Full Width |