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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Need for primary keys

Re: Need for primary keys

From: Allan Nelson <anelson77388_at_gmail.com>
Date: Thu, 31 May 2007 12:56:39 -0500
Message-ID: <ffb96860705311056u4cd00c1cr62fc9e6a5698be6a@mail.gmail.com>


Yes, it is true that E-Business does that, but that doesn't mean it is a good idea. Oracle has lots of bad code and bad practices in E-Business. No need to perpetuate it to innocent bystanders.

Allan

On 5/31/07, John Clarke <jclarke_at_centroidsys.com> wrote:
>
> Absence of primary keys does not necessarily equate to lack of
> uniqueness. You can just as easily have unique indexes enforcing integrity
> on your tables (Oracle E-Business Applications for the most part does just
> this very few primary/foreign keys, lots of unique indexes and application
> logic maintaining integrity).
>
>
>
> Best to assess the true risk before raising a red flag.
>
>
> ------------------------------
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Allan Nelson
> *Sent:* Thursday, May 31, 2007 10:16 AM
> *To:* BLock_at_dvfs.com
> *Cc:* oracle-l_at_freelists.org
> *Subject:* Re: Need for primary keys
>
>
>
> This is very bad news.
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu May 31 2007 - 12:56:39 CDT

Original text of this message

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