Re: HOW TO SET SEQUENCE VALUE

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 29 Mar 2012 14:13:51 +0100
Message-ID: <CABe10sYBuw2JvVs4DGWf1Ue6uO9HpA7Lsp=811+Fq86iKD8f7A_at_mail.gmail.com>

apparently I should have read all the other replies first. The "right" solution will inevitably involve serialization on a number generator, and so probably won't scale particularly well. On Thu, Mar 29, 2012 at 2:11 PM, Niall Litchfield < niall.litchfield_at_gmail.com> wrote:

> If losing sequence numbers is not allowed then sequences are the wrong
> solution, regardless of CACHE|NOCACHE.

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info


--
http://www.freelists.org/webpage/oracle-l

Received on Thu Mar 29 2012 - 08:13:51 CDT