Re: Re:identifying a database

Marin,

If you don't like SYS_GUID() returning RAW, you can use rawtohex(SYS_GUID()), it will return character string, containing hex representation.

Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
ineyman_at_perceptron.com

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, October 23, 2001 12:10 PM

>
> ----- Original Message -----
> To: "Marin Dimitrov" <marin.dimitrov_at_sirma.bg>; "Multiple recipients of
list
> ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Tuesday, October 23, 2001 17:48
>
>
> > Marin,
> >
> > Not sure I understand the question. Each database needs a unique
sid
> on
> > that machine. You can use the same sid on different computers, but not
on
> the
> > same one. According to MetaLink DBID is not a unique indicator.
> >
>
> I don't want to mess with SIDs, what I need is a globally unique
identifier
> of the database (or one with sufficiently small probability of being
> duplicated)
>
> The reason I need this is because in the application a user may read some
> object from a database and when he tries to save the object back I need to
> be sure that the database used is the same as the one the object
originates
> from (one usually deals with few objects from different databases)
>
> So, if DBID is not unique how could I generate an almost globally unique
> number?
> (I don't quite like calling SYS_GUID() because it returns RAW)
>
>
> thanx,
>
> Marin
>
> ----
> "...what you brought from your past, is of no use in your present. When
> you must choose a new path, do not bring old experiences with you.
> Those who strike out afresh, but who attempt to retain a little of the
> old life, end up torn apart by their own memories. "
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Marin Dimitrov
> INET: marin.dimitrov_at_sirma.bg
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Igor Neyman
  INET: ineyman_at_perceptron.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).