"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message
news:kr9pfv8kb2pecgmgtjvrd7gafcukljh3jt_at_4ax.com...
> On Fri, 27 Jun 2003 13:15:40 -0700, "Mikito Harakiri"
> <mikharakiri_at_ywho.com> wrote:
>
> >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".
>
>
> That's also my impression. And of course, people using Oracle Apps are
> still forced to run Oracle 8.1.6 server *and* Oracle 8.0.6 client.
> Oracle Apps, from the technical view, is just a big mess, and the
> worst product they ever sold.
Check out 9iAS - a recipe for consultancy and eternal upgrades if ever I saw
one.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Fri Jun 27 2003 - 15:41:06 CDT
