Re: Oracle Myths

From: D.Y. <dyou98_at_aol.com>
Date: 21 May 2002 12:10:48 -0700
Message-ID: <f369a0eb.0205211110.3945c5c4@posting.google.com>

nsouto_at_optushome.com.au (Nuno Souto) wrote in message news:<dd5cc559.0205151517.4b43fe1e_at_posting.google.com>...
> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:<3ce21b71$0$8510$ed9e5944_at_reading.news.pipex.net>...
> > Suggested list to be added to, deleted from etc
> >
>
>
> One more I've been hitting very often of late:
>
> - You cannot create declarative RI across schemas. Oracle doesn't let
> you do it.
> (could it be these people have never heard of the REFERENCES grant?)
>

The first time I heard this.

> - Defining RI in application code is safer and less maintenance
> intensive than doing it in the databse.
>

A while ago some people did this for portability reasons when, for example, RI was available in Oracle but not Sybase.

>
> Sometimes I wonder...
> Cheers
> Nuno
Received on Tue May 21 2002 - 14:10:48 CDT