Re: Oracle Takeover Bid of PeopleSoft Falls Through

From: Mikito Harakiri <mikharakiri_at_ywho.com>
Date: Fri, 27 Jun 2003 13:15:40 -0700
Message-ID: <GI1La.15$2b5.85@news.oracle.com>

select * from dba_constraints
where owner in ('APPS', 'HZ', 'APPLSYS') and constraint_type = 'R'

returned just 2 foreign keys in 11.5.8. I also don't see anything but "not null" constraints on gl_interface table. I beleive they have a metalink note with motivation why constraints are considered "bad".

"Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message news:3EFC8DEA.D292B644_at_exxesolutions.com...
> Mikito Harakiri wrote:
>
> > "Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message
> > news:3EEB57EA.4177408A_at_exxesolutions.com...
> > > Go for it Larry. And after you've bought it ... if they can't
understand
> > the concept of a foreign key ...
> > > close 'em down.
> >
> > Hmm... Do oracle apps folks understand what referential constraint (aka
> > foreign key) is?
>
> Last time I checked the gl_interface table, alone, had 17 referential
> constraints.
>
> The equivalent table in the competing products ... zero.
> --
> Daniel Morgan
> http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
>
Received on Fri Jun 27 2003 - 15:15:40 CDT