Re: On delete cascade

tkyte_at_us.oracle.com (Thomas J Kyte) wrote:

>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.

Don't worry, Thomas; some people never will understand basic relational theory. Ya buy 'em book, ya buy 'em books, and the just chew the covers off.

Michael B. Openshaw
Integrated Medical Networks
(Opinions expressed are my own) Received on Sat Mar 23 1996 - 00:00:00 CET