Re: Constraint and delete cascade

Hi Yann,

You asked a question on something you were confused about.

You (fortunately) received an answer that pointed you to the solution to your problem.

I don't see anything too stupid about that !!

Cheers

Richard
"Yann boucounaud" <yboucounaud_at_ebi-fr.com> wrote in message news:ai90mv$ll0$1_at_reader1.imaginet.fr...
> You are right .
> I discover there is another user who delete too many rows in the table
> during this operation .
> I am sorry for my stupid question .
>
> Thanks a lot
>
> YB
>
> "Richard Foote" <richard.foote_at_bigpond.com> a écrit dans le message de
news:
> qPR19.49678$Hj3.148553_at_newsfeeds.bigpond.com...
> > Hi Yann,
> >
> > Not sure why the dropping of a FK constraint (with or without delete
> > cascade)would cause much redo generation ???
> >
> > You're not talking about dropping the column (or table) or something
> > completely different are you ? You're sure there's not another activity
in
> > the database that could cause the log generations ?
> >
> > Can you show the alter table command you performed and how long it took
?
> >
> > Mucho curious ...
> >
> > Richard
> > "Yann boucounaud" <yboucounaud_at_ebi-fr.com> wrote in message
> > news:ai8e93$hao$1_at_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 Thu Aug 01 2002 - 02:33:41 CDT