Re: alter table disable constraint

you help will be greatly appreciated

"Howard J. Rogers" wrote:

> "Naushi Hussain" <naushi.hussain_at_alliedsignal.com> wrote in message
> news:3A802540.F4FDA1A1_at_alliedsignal.com...
> > 1) I did an alter table disable primary key cascade and it worked. Now
> > I like to enable it. Will enabling automatically recreate the FK
> > constraint?
> >
>
> No. There's no 'enable constraint cascade' syntax.
>
> > 2) Also I tried looking in dba_constraints table for the table this key
> > is a FK to. But I could not find the related table_name even in the
> > R_CONSTRAINT_NAME. How can I find the name of the (child) table where
> > the primary key of a (parent) table is a foreign key.
> >
>
> There's some fairly standard syntax that covers this -and I don't have it to
> hand. If you've been on the Backup and Recovery course, it's included in
> the Oracle course notes for that. If no-one's posted anything else by this
> evening, I'll have it for you then (it's currently 6am-ish).
>
> Regards
> HJR
>
> > will appreciate any suggestions
> >
  Received on Tue Feb 06 2001 - 13:51:35 CST