On 29/03/12 13:49, Taylor, Chris David wrote: > Can you clarify an instance where a NOCACHE sequence number would be lost? Any time you rollback a transaction would lose a value. (Which is basically what you said). Cheers, Norm. -- Norman Dunbar Dunbar IT Consultants Ltd Registered address: Thorpe House 61 Richardshaw Lane Pudsey West Yorkshire United Kingdom LS28 7EL Company Number: 05132767 -- //www.freelists.org/webpage/oracle-l