Re[2]: Sequences in OPS/RAC

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Mon, 03 Nov 2003 09:04:26 -0800
Message-ID: <F001.005D5753.20031103090426@fatcity.com>

Hello Hemant,

Monday, November 3, 2003, 11:29:26 AM, you wrote:

HKC> However, the Builder.Com article quite explicity asserts
HKC> "Sequence generator numbers are guaranteed to be unique only for a single 
HKC> instance, which is unsuitable for use as a primary key in parallel or 
HKC> remote environments, where a sequence in each environment might generate 
HKC> the same number and result in conflicts

Can you point us to the article? My guess is that the author is not familiar with Oracle, and is basing the above statement on his experience with some other database (DB2 perhaps?). There is no problem with using sequence numbers in a RAC. No conflicts will occur. I've never heard of a problem in that regard.

Best regards,

Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:jonathan@gennick.com

Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to Oracle-article-request_at_gennick.com and include the word "subscribe" in either the subject or body.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Jonathan Gennick
  INET: jonathan_at_gennick.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Nov 03 2003 - 11:04:26 CST