Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!feed.news.nacamar.de!newsfeed.ision.net!news.is-europe.net!ision!not-for-mail From: "Guido Konsolke" Newsgroups: comp.databases.oracle.misc Subject: Re: Generating global ID Date: Thu, 12 Dec 2002 09:58:41 +0100 Organization: Ye 'Ol Disorganized NNTPCache groupie Lines: 37 Message-ID: <1039683286.33426@news.thyssen.com> References: <1039618021.392344@news.thyssen.com> NNTP-Posting-Host: 149.211.49.31 X-Trace: goliath.news.is-europe.net 1039683522 10263 149.211.49.31 (12 Dec 2002 08:58:42 GMT) X-Complaints-To: abuse@is-europe.net NNTP-Posting-Date: 12 Dec 2002 08:58:42 GMT X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Cache-Post-Path: news.thyssen.com!unknown@170.56.164.197 X-Cache: nntpcache 2.3.3 (see http://www.nntpcache.org/) Xref: newsfeed1.easynews.com comp.databases.oracle.misc:90465 X-Received-Date: Thu, 12 Dec 2002 01:58:20 MST (news.easynews.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" schrieb im Newsbeitrag news:at7jso$11q78e$1@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