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: Matthias Rogel <rogel_at_web.de>
Date: Wed, 11 Dec 2002 14:34:36 +0100
Message-ID: <at7etc$10vfh5$1@ID-86071.news.dfncis.de>


select sys_guid() from dual;

GUID=globally unique identifier

ja ist denn schon weihnachten ?

Rolf Knaden wrote:
> 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,
>
> Rolf Knaden
> rk_at_technosoft.de
>
>
>
>
Received on Wed Dec 11 2002 - 07:34:36 CST

Original text of this message

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