Re: On delete cascade

From: Thomas J Kyte <tkyte_at_us.oracle.com>
Date: 1996/03/22
Message-ID: <4it2lu$fu8_at_inet-nntp-gw-1.us.oracle.com>#1/1

ghp_at_infosoft.be (Gerard H. Pille) wrote:

>In article <4is48h$2rn_at_kuikka.inet.fi>, Sakari Lampola
>(Sakari.Lampola_at_cybersoft.inet.fi) says...
>!>
>!>
>!>Has anybody ever used "on delete cascade" option with foreign keys
>!>to guard referential integrity in a real production database ?
>!>Any problems ?
>!>
>!>Just curious,
>!>
>!>Sakari Lampola
>!>Cybersoft
>!>Finland
>!>
>!>
>I would never use it, it makes you loose half of the referential
>integrity.
>--
>Kind reGards
> \ / |
> X |
> / \ s
> Gerard

Elaborate please. What do you mean by 'you loose half of the referential integrity'. I use on delete cascade in many places in production.

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government

---

opinions and statements are mine and do not necessarily reflect the opinions of Oracle Corporation. Received on Fri Mar 22 1996 - 00:00:00 CET