Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Constraint and delete cascade

Re: Constraint and delete cascade

From: Yann boucounaud <yboucounaud_at_ebi-fr.com>
Date: Wed, 31 Jul 2002 12:41:11 +0200
Message-ID: <ai8e93$hao$1@reader1.imaginet.fr>


Yes ,but oracle generate many logs during the deleting of the constraint . Is it normal ? Or is it an another operation that create so many logs ?

Thanks

"Richard Foote" <richard.foote_at_bigpond.com> a écrit dans le message de news: DRO19.49366$Hj3.147371_at_newsfeeds.bigpond.com...
> Hi Yaan,
>
> Ummmm, no.
>
> If I understand your question correctly, you have a FK constraint with
> delete cascade that you want to drop ? Well the constraint is dropped and
> deleted from the Data Dictionary and that's about it. The column(s) in
> question are no longer related to any PK or UK and can hence contain any
> value.
>
> That's all !
>
> Richard
> "Yann boucounaud" <yboucounaud_at_ebi-fr.com> wrote in message
> news:ai8ckb$gvq$1_at_reader1.imaginet.fr...
> > Hi everybody
> >
> > Does someone known what happen physicaly when a constraint with delete
> > cascade is dropped ?
> > Each tables are dopped and recreated ?
> >
> > thanks
> >
> > YB
> >
> >
> >
>
>
Received on Wed Jul 31 2002 - 05:41:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US