Re: inability to drop table dur to unknown enables FK

From: Business Information Services <email_at_bisinfo.com.au>
Date: 1997/10/07
Message-ID: <MPG.ea40e891415eef9989688@nsw-newshost.tpgi.com.au>#1/1

[This followup was posted to comp.databases.oracle.misc and a copy was sent to the cited author.]

In article <34374301.16DC_at_shani.net>, ordnkv_at_shani.net says...
> Problem : Inability to drop table due to unknown enables
> FK which references the table.
>
> Situation : All known FK referencing the table were disable.
Something else must be hanging around.

> All data in FK tables was deleted.

That won't matter. It's a constraint problem not a data one.

> Drop table failed due to 'unique/primary key referenced by enabled
> foreign keys'.

> Questions :
> 1. In which table can we find all FK referencing a particular
> table ?

USER_CONSTRAINTS
> 2. Does DROP TABLE require dropping all the FK or just disabling
> them is enough ?

Dropping. Bummer I know.

> 3. If there is no table with FK references, what do you suggest
> as a solution to our problem ? :

I'm sure there will be a table referencing the primary key of the table you are trying to drop. Query the USER_CONSTRAINTS table.

Regards,
Rowan. Received on Tue Oct 07 1997 - 00:00:00 CDT