Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Generating a GUID
My error -
Reading the manual (always a help) I see that sys_guid()
is supposed to be globally unique. To paraphrase the manual:
It comprises (on most platforms)
the machine identity
the thread/process identifier of the current thread/process
a monotonically increasing meaningless sequence number
-- Jonathan Lewis Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk Luca Minudel wrote in message <01c03d38$3f0c2f80$d56e1997_at_w95luca>... In OO environments the GUID concept is quite frequent. In OO persistence environments the GUID concept is ALWAYS present. I find really strange that Oracle8i with it's O-R model does not provide a way to generate it... Anyway, how does Oracle8i manage a situation where you export a table of objects an a table that has references to that objects and than you import that rows in another Db (with the same schema)? How doest it assure that OIDs from the two Db don't collide? _______________________________________ Luca Minudel Consulente Informatico luca.minudel_at_nline.it Conegliano (TV) WWW http://www.nline.it/consulting Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> scritto nell'articolo <972331077.587.0.nnrp-07.9e984b29_at_news.demon.co.uk>...Received on Tue Oct 24 2000 - 12:23:40 CDT
>
> How G do you want you UID ?
>
> There is a function SYS_GUID() which Oracle
> uses to generate a globally unique ID for objects
> within a database.
> e.g.
> select sys_guid() from dual;
>
>
> If you want a really UUID you might do better
> to call to an operating system that supplies them.
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> ringosoft_at_my-deja.com wrote in message <8t235n$fqb$1_at_nnrp1.deja.com>...
> >Is there a way in Oracle 8i to generate a GUID or UUID? If not
> >directly, can I call the OS from a stored proc to do this? On Linux? On
> >Solaris? TIA.
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Before you buy.
>
>
>