Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: One SEQUENCE, many tables .. need advice

Re: One SEQUENCE, many tables .. need advice

From: Ian Ledzion <ian.ledzion_at_lgxbow.com>
Date: Wed, 4 Jul 2001 10:37:33 +0200
Message-ID: <9hukjh$6l5$1@rex.ip-plus.net>

Thought both approaches are equally valid, I'd go for the single sequence option on the basis that you then have a Unique Object Identifier in you database.

"Anne Nolan" <anolan_at_enabletech.com> wrote in message news:3B42325E.3A7DCAD8_at_enabletech.com...
> Hi all,
>
> I'm working on designing a whole new database. I've decided to go with
> surrogate keys generated from sequences for most of the primary keys in
> the tables.
>
> Is it OK or even advisable to use one sequence for generating all these
> keys? Or should each table have its own sequence for generating its
> keys? I presume there is no ultimate upper limit to how big a
> sequence value can get..is this true?
>
> Thanks in advance for any and all advice on this, and sorry if this is a
> FAQ. (I did a quick search on this topic, but could find nothing.)
>
> Anne
>
>
Received on Wed Jul 04 2001 - 03:37:33 CDT

Original text of this message

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