RE: global sequence as unique identifier across multiple databases

From: Kerber, Andrew W. <Andrew.Kerber_at_umb.com>
Date: Wed, 18 Jul 2007 08:37:39 -0500
Message-ID: <D40740337A3B524FA81DB598D2D7EBB3097A8755@x6009a.umb.corp.umb.com>

He misses one method. Just use one sequence on one instance, and have all the other instances use db links to pop the sequence as necessary. This has the drawback of needing your network up, and losing time pulling the nextval across the network. If you are worried about security, it should be possible to secure the link for only that purpose, and hide it within code or function, and even wrap some more logic around it as necessary.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Clarke, Andrew
Sent: Wednesday, July 18, 2007 5:31 AM
To: nigel_cl_thomas_at_yahoo.com; paulastankus_at_yahoo.com Cc: oracle-l_at_freelists.org
Subject: RE: global sequence as unique identifier across multiple databases

Oracle FAQs has a list of all the various options, with a bonus "sheesh!" style comment from Noons ;)

http://orafaq.com/node/1406

Cheers, APC

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Nigel Thomas
Sent: 18 July 2007 10:29
To: paulastankus_at_yahoo.com
Cc: oracle-l_at_freelists.org
Subject: Re: global sequence as unique identifier across multiple databases

Paula

This has been asked before on this list Is it possible to share a database sequence between multiple databases? <http://www.freelists.org/archives/oracle-l/02-2007/msg01023.html> . Mark Powell suggested use of SYS_GUID as an alternative to sequence ranges, or intercalated sequences as just suggested by Glints. I blogged here
http://preferisco.blogspot.com/2007/02/unique-ids-for-multi-master-repli cation.html that sadly SYS_GUID (in my test at least - OracleXE on a laptop, YMMV) is quite a bit slower than selecting from a sequence.

Regards Nigel

This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you.

NOTICE: This electronic mail message and any attached files are confidential. The information is exclusively for the use of the individual or entity intended as the recipient. If you are not the intended recipient, any use, copying, printing, reviewing, retention, disclosure, distribution or forwarding of the message or any attached file is not authorized and is strictly prohibited. If you have received this electronic mail message in error, please advise the sender by reply electronic mail immediately and permanently delete the original transmission, any attachments and any copies of this message from your computer system. Thank you.

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

Received on Wed Jul 18 2007 - 08:37:39 CDT