Re: HOW TO SET SEQUENCE VALUE
From: Norman Dunbar <oracle_at_dunbar-it.co.uk>
Date: Thu, 29 Mar 2012 14:04:37 +0100
Message-ID: <4F745DE5.2070401_at_dunbar-it.co.uk>
On 29/03/12 13:49, Taylor, Chris David wrote:
> Can you clarify an instance where a NOCACHE sequence number would be lost?
Date: Thu, 29 Mar 2012 14:04:37 +0100
Message-ID: <4F745DE5.2070401_at_dunbar-it.co.uk>
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 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 29 2012 - 08:04:37 CDT