Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: GUID's and uniqueness

Re: GUID's and uniqueness

From: Louis Frolio <froliol_at_yahoo.com>
Date: 15 Sep 2004 05:17:14 -0700
Message-ID: <94c28610.0409150417.4002f7bc@posting.google.com>


Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1095218401.235027_at_yasure>...
> Louis Frolio wrote:
>
> > Greetings All, I have read many upon many articles here regarding GUID
> > data types and uniqueness. There have been many opinions regarding
> > the effectiveness of GUID's and when they should/should not be used.
> > However, every article strongly implies, if it does not state it
> > outright, that GUID's are always unique. My question is this, what
> > happens if you have a database that uses GUID's and the NIC is changed
> > out on the box? From what I understand the MAC address of the NIC is
> > used as part of the algorithm to generate a GUID. If you change out
> > the NIC after generating 1 billion GUID's do you run the chance of
> > generating a duplicate GUID?
> >
> > I look forward to your insightfulness on this issue.
> >
> > Regards, Louis.
>
> GUIDs are not unique except in very specific controlled situations.
> They are highly likely to be unique ... but there are not guarantees.
> And I have personally seen problems where they weren't.

Daniele, would be so kind as to elaborate a bit with regards to the situation where duplicate GUID's appeared? I ask because I am designing an application that requires that it be replication friendly, and not just one way replication. I need the app to be able to do two way replciation to multiple nodes. So, any details you can provide regarding your experience with GUID's would be hugely helpful to me.

Regards, Louis. Received on Wed Sep 15 2004 - 07:17:14 CDT

Original text of this message

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