RE: global sequence as unique identifier across multiple databases
- From: "Kerber, Andrew W." <Andrew.Kerber@xxxxxxx>
- To: andrew.clarke@xxxxxxxxxxxxx, nigel_cl_thomas@xxxxxxxxx, paulastankus@xxxxxxxxx
- Date: Wed, 18 Jul 2007 08:37:39 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Clarke, Andrew
Sent: Wednesday, July 18, 2007 5:31 AM
To: nigel_cl_thomas@xxxxxxxxx; paulastankus@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Nigel Thomas
Sent: 18 July 2007 10:29
To: paulastankus@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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?
<//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.
==============================================================================
Other related posts:
