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.