Re: Constraint and delete cascade

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 - 08:49:36 CDT