Re:identifying a database

From: <dgoulet_at_vicr.com>
Date: Tue, 23 Oct 2001 08:09:47 -0700
Message-ID: <F001.003B232A.20011023075023@fatcity.com>

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.

Dick Goulet

____________________Reply Separator____________________
Author: "Marin Dimitrov" <marin.dimitrov_at_sirma.bg>
Date:       10/23/2001 7:30 AM

Hi,

what is the best way to uniquely identify a database?

1. grant access to the user to v$database and use DBID?
   (how unique is the DBID?)
   

B.generate a unique ID somehow
(some PL/SQL package to use?)

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: 
  INET: dgoulet_at_vicr.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).

Received on Tue Oct 23 2001 - 10:09:47 CDT