unique ID - globally

From: S P Arif Sahari Wibowo <arifsaha_at_null.net>
Date: 2000/02/18
Message-ID: <Pine.LNX.4.21.0002181604350.3348-100000_at_macbeth.tirone.com>#1/1

Hi!

Do you know how to make a unique ID for primary key - globally?

It seems like people agree that the best unique ID locally - in once server - is using the sequence, right? But how about unique ID from multiple server, that not necessarily have good connection between them?

What I am thinking of is concatenate the sequence number from one server with one number that uniq to a server, IP number probably? Well, how oracle can find out its own IP number?

Other idea?

Thank you.

-- 
                                   S P Arif Sahari Wibowo
  _____  _____  _____  _____ 
 /____  /____/ /____/ /____          arifsaha_at_null.net
_____/ /      /    / _____/       http://www.arifsaha.com/

Received on Fri Feb 18 2000 - 00:00:00 CET

This message: [ Message body ]
Next message: Thomas Kyte: "Re: unique ID - globally"
Previous message: shreek_m_at_my-deja.com: "ODBC error"
Next in thread: Thomas Kyte: "Re: unique ID - globally"
Reply: Thomas Kyte: "Re: unique ID - globally"
Reply: S P Arif Sahari Wibowo: "Re: unique ID - globally"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message