Re: Constraint and delete cascade

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 Wed Jul 31 2002 - 10:55:48 CDT