Title: RE: On delete cascade
Stephanie, wouldn't it be easy enough to find out what is referencing what? If the developer doesn't know, just
ask the DBA. If the DBA doesn't know, then time to find another one. The use of ON DELETE CASCADE is commonly use
to maintain dat
Fawzia,
I'm going to disagree with just about everybody on this one. Assuming, and
that is a BIG assumption, that the parent and child relationships have been
properly established there is no real good reason not to use 'on delete
cascade'. I've one &^%$ duhveloper
>From: "Malik, Fawzia" <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L
><[EMAIL PROTECTED]>
>Sent: Tue, 18 Jun 2002 03:38:25
>
>
>Hi Gurus,
>
>I have just been told by a colleague that I must
>not use "On del
gt;
Sent: Tuesday, June 18, 2002 1:38 PM
>
> Hi Gurus,
>
> I have just been told by a colleague that I must not use "On delete
Cascade"
> as for sure it could have serious negative implications We need to be
> able to remove an entry and to avoid writing a script (del
Hi Gurus,
I have just been told by a colleague that I must not use "On delete Cascade"
as for sure it could have serious negative implications We need to be
able to remove an entry and to avoid writing a script (deleteing children
then parent) I was just doing to set the above
While a ON DELETE trigger would do what you want, why don't you want to rebuild the
constraint?
>>> [EMAIL PROTECTED] 07/24/01 08:05AM >>>
sounds like a trigger is needed.
joe
Ranganath K wrote:
>
> Dear DBA Gurus,
> How to add the functionality of "on d
sounds like a trigger is needed.
joe
Ranganath K wrote:
>
> Dear DBA Gurus,
> How to add the functionality of "on delete cascade" to an existing foreign
> key constraint without dropping the constraint and recreating it using
> "Alter" command?
> Thanks an
Dear DBA Gurus,
How to add the functionality of "on delete cascade" to an existing foreign
key constraint without dropping the constraint and recreating it using
"Alter" command?
Thanks and Regards,
Ranganath
DISCLAIMER: This correspondence is confidential and intended for t