Re: alter table disable constraint

From: Howard J. Rogers <howardjr_at_www.com>
Date: Wed, 7 Feb 2001 06:37:59 +1100
Message-ID: <3a805299@news.iprimus.com.au>

"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:37:59 CST