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: Generating global ID

Re: Generating global ID

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Wed, 11 Dec 2002 16:00:40 GMT
Message-ID: <IiJJ9.313647$NH2.22118@sccrnsc01>


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

Original text of this message

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