Re: Need for primary keys
- From: "Allan Nelson" <anelson77388@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 31 May 2007 12:56:39 -0500
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:
