Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: unique ID - globally

Re: unique ID - globally

From: S P Arif Sahari Wibowo <arifsaha_at_tirone.com>
Date: Mon, 21 Feb 2000 16:22:42 -0600
Message-ID: <Pine.LNX.4.21.0002211520120.10882-100000@macbeth.tirone.com>


On 19 Feb 2000, Sean P Murphy wrote:

>> Do you know how to make a unique ID for primary key - globally?
> If they do not need to be sequential, how about a date/time stamp
>YYYYMMDDHH24MISS???? Is this feasible?

They don't have to be sequential, but time stamp alone won't be enough, since the possibility of two object created in the same second is high, not counting the possibility of the clock not entirely correct, and therefore may move backward when the clock is adjusted.

Thank you, though.

--

                                   S P Arif Sahari Wibowo
  _____  _____  _____  _____         Tirone Corporation
 /____  /____/ /____/ /____          arifsaha_at_tirone.com
_____/ /      /    / _____/         http://www.tirone.com/


Received on Mon Feb 21 2000 - 16:22:42 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US