Re: Need for primary keys

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