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