Re: Storing GUIDs in Oracle

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 23 Jul 2003 23:40:59 +0200
Message-ID: <650uhvspopo9mh3gdihgq6eqke08ac6hit@4ax.com>

On Wed, 23 Jul 2003 16:52:15 -0400, "Jeff Boenig" <jeff.boenig_at_elsitech.com> wrote:

>I've also considered using an 64 bit integer for my primary keys instead. I
>lose global uniqueness, but I would gain a more efficient index. Anyone know
>of any caveats to using 64-bit integers as primary keys?

Oracle doesn't have native 64-bit integers. Numbers are basically stored as packed decimals. However number columns don't have the problems asssociated with RAWs

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Jul 23 2003 - 16:40:59 CDT