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@xxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxx [mailto:
oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Allan Nelson
*Sent:* Thursday, May 31, 2007 10:16 AM
*To:* BLock@xxxxxxxx
*Cc:* oracle-l@xxxxxxxxxxxxx
*Subject:* Re: Need for primary keys



This is very bad news.

Other related posts: