Hi all,

Can anybody tell me how the database ID is "generated"
SQL> select DBID from v$database;

DBID
----------
2321854517

SQL>

I'm just wondering how this number/ID is made up, or what it is
composed of.

As you can see below we are on a database 9.2.0.7 (on AIX 5.2)
SQL> select banner from v$version;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
PL/SQL Release 9.2.0.7.0 - Production
CORE 9.2.0.7.0 Production
TNS for IBM/AIX RISC System/6000: Version 9.2.0.7.0 - Production
NLSRTL Version 9.2.0.7.0 - Production

SQL>

Best Regards,

Martijn Bos

It is generated when you create the database, or run a utlity to change
it
http://download-west.oracle.com/docs...15/dbnewid.htm

It is created to be unique so RMAN (or other restoration techniques)
can figure out what goes where.

jg
--
@home.com is bogus.
http://www.danacountryman.com/danaco...anacovers.html

Hee Joel,

Thanks for your reply.
I allready knew when the ID is created or how to change it :-)

I'm looking for how it's created. For instance is it a random number,
or is it a hash of (let's say) the SID and the time.

It's not to important, but I just like to know.

Best Regards,

Martijn Bos