Re: Generating global ID

From: Matthias Rogel <rogel_at_web.de>
Date: Wed, 11 Dec 2002 17:02:55 +0100
Message-ID: <at7njf$11jdba$1@ID-86071.news.dfncis.de>

tojo wrote:

> In article <at7e3t$uip$1_at_news-in.kamp.net>, rk_at_technosoft.de says...
> 

>>Hi everyone.
>>
>>In our database we have objects which are identified by an id. The id is
>>generated by a sequence and thereby is unique in this database.
>>Now I have the problem of merging the contents of two databases.
>>Therefore it would be nice to have an id, that is unique over all databases,
>>although there is no database-link between the databases. Then I only had to
>>put the objects of the one db into the other db.
>>Does anyone know, how to generate such an id?
>>Thanks and merry christmas,

> 
> 
> Before you poison any key fields with guid's, let me offer another 
> suggestion: create sequences with differenct value ranges. On DB1, say, 
> 1 to 10000000, on DB2 10000001 to 20000000, etc.
> 
> -- Tom

where is the poison in a RAW(32)-primary key ?

Matthias Received on Wed Dec 11 2002 - 10:02:55 CST