Re: FW: v$database DBID

Hi,

The algorithm used to generate the DBID is not documented.

As for its uniqueness: if a database is duplicated without RMAN and without using the "nid" utility, it will have the same DBID as the primary one.

Moreover we can't assume that "create database" or "nid" generate a DBID that is 100% guaranteed unique on earth. The only piece of information we can obtain about it is that's a number(22)= .

Jerome

On 6/12/05, Todd Carlson <tcarlson_at_tripos.com> wrote:
>=20
> Hey Guys,
>=20
> The docs are kind of weak when it comes to how the DBID of v$database is
> generated. Does anyone know how Oracle is generating this number and how
> 'unique' it actually is?=3D20
>=20
> Thanks,
>=20
> Todd
>=20
>=20
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l