Missing sequences... how to retrieve the missing no?

[Quoted] Dear Netizens

[Quoted] I am facing the issue of missing sequence number in one of our tables. I [Quoted] had set the sequence number to nocache. Hence, the system is slow and [Quoted] will need to retrieve the number from the disk whenever it is needed.

[Quoted] However, individual sequence numbers can be skipped if they were generated and used in a transaction that was ultimately rolled back. How [Quoted] do I make provisions to catch and reuse these sequence numbers?

Thanks in advanced.

Rgds,

Jessica
<jesskung_at_brel.com> Received on Tue May 09 2000 - 00:00:00 CEST