Re: alter table disable constraint

From: <sunk_at_focushope.edu>
Date: Tue, 06 Feb 2001 16:59:27 GMT
Message-ID: <95pah8$c70$1@nnrp1.deja.com>

In article <3A802540.F4FDA1A1_at_alliedsignal.com>, Naushi Hussain <naushi.hussain_at_alliedsignal.com> wrote:
> 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?
>
> 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.
>
> will appreciate any suggestions

You can use OEM to locate the table and find dependency info(right click).

HTH, Kurt.

>
>

Sent via Deja.com
http://www.deja.com/ Received on Tue Feb 06 2001 - 10:59:27 CST