Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Generating global ID
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.