Re: global sequence as unique identifier across multiple databases

From: Nigel Thomas <nigel_cl_thomas_at_yahoo.com>
Date: Wed, 18 Jul 2007 02:28:54 -0700 (PDT)
Message-ID: <767028.95994.qm@web58713.mail.re1.yahoo.com>

Paula This has been asked before on this list Is it possible to share a database sequence between multiple databases?. 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-replication.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

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

Received on Wed Jul 18 2007 - 04:28:54 CDT

This message: [ Message body ]
Next message: Laimutis Nedzinskas: "Windows Active Directory, MIT kerberos, KDC and Oracle Advanced Security"
Previous message: goran bogdanovic: "rman catalog and current controlfile"
Maybe in reply to: Gints Plivna: "Re: global sequence as unique identifier across multiple databases"
Next in thread: Laimutis Nedzinskas: "Windows Active Directory, MIT kerberos, KDC and Oracle Advanced Security"
Reply: Laimutis Nedzinskas: "Windows Active Directory, MIT kerberos, KDC and Oracle Advanced Security"
Reply: Clarke, Andrew: "RE: global sequence as unique identifier across multiple databases"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US