Re: Generating global ID

From: Guido Konsolke <Guido.Konsolke_at_triaton.com>
Date: Thu, 12 Dec 2002 09:58:41 +0100
Message-ID: <1039683286.33426@news.thyssen.com>

Hi Matthias,

*duck*. Sorry for posting before (sufficient) testing: I issued the command 2 times and was not able to recognize the obvious difference between the results. Too tired? Too silly? I prefer not to think about it.

"Matthias Rogel" <rogel_at_web.de> schrieb im Newsbeitrag news:at7jso$11q78e$1_at_ID-86071.news.dfncis.de...
> Hallo Guido,
>
> no, sys_guid() *MUST* return a *globally unique identifier*
> that means
> calling sys_guid on one Oracle Server MUST *NEVER* return the same value
> as calling sys_guid anytime on the same (or another) server.
> otherwise you can blame Oracle for a buggy implementation.
>
> there is no need to concatenate this with a sequence.
> I don't understand why you want to do that.

Please see above...

>
> Matthias

(SNIP)
>
>
> Ja, ich freu' mich auch schon tierisch auf silvester !!

I TOTALLY AGREE! HoHoHo,
Guido Received on Thu Dec 12 2002 - 02:58:41 CST