Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Generating global ID
Do as Tom suggests or concat a constant string and make it a string field.
(eg db1,)
Jim
"tojo" <Tojo_at_hotmail.com> wrote in message
news:MPG.18617ad295e160209896db_at_news.t-online.de...
> 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
Received on Wed Dec 11 2002 - 10:00:40 CST
![]() |
![]() |