Re: SAP/Oracle

• Original Message ----- From: <jo_holvoet_at_amis.com>

> * SAP will try its darndest to keep you out of the database except through
> their tools (such as sapdba) which introduce interesting new bugs

apparently, that's to improve "portability"...

> * In our instance : 21303 tables; foreign key constraints : 0 (yep, zero)

apparently, that's to improve "portability"...

> * SAP keeps track of its objects in its own data dictionary. Of course,
> the mapping between what SAP says is a table and what Oracle says is a
> table is NOT 1-to-1.

apparently, that's to improve "portability"...

> * Things you think are numbers, dates, ... are almost always stored in
> varchar columns

apparently,...

you get the picture, don't you?
Cheers
Nuno Souto
nsouto_at_bizmail.com.au

--
http://www.freelists.org/webpage/oracle-l