Re: inability to drop table dur to unknown enables FK

From: Jomarlen <jomarlen_at_aol.com>
Date: 1997/10/05
Message-ID: <19971005190701.PAA19600@ladder01.news.aol.com>#1/1

Hi

If you visit my web site
http:/./members.aol.com/jomarlen
on my Oracle Utilities page you
will find the ddl for a view
ALL_FK_CONSTRAINTS
which allows you to easily see
the FK relationships, both
within a schema and across
schemas.

John

---

John C. Lennon
Utility Partners Inc.
4300 West Tropicana Blvd LVO-UPL
Las Vegas NV 89103

FOR UTILITY PARTNERS EMPLOYMENT
OPPORTUNITIES VISIT www.utilpart.com

e-mail: jomarlen_at_aol.com
Web Site: http://members.aol.com/jomarlen/

The views expressed in this message
are those of the author and not
necessarily those of U.P. Inc.
and/or its employees.

---

>Subject: inability to drop table dur to unknown enables FK
>From: Yochi Wieman <ordnkv_at_shani.net>
>Date: Sun, Oct 5, 1997 03:34 EDT
>Message-id: <34374301.16DC_at_shani.net>
>
>Problem : Inability to drop table due to unknown enables
>FK which references the table.
>
>Situation : All known FK referencing the table were disable.
>All data in FK tables was deleted.
>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 ?
>2. Does DROP TABLE require dropping all the FK or just disabling
>them is enough ?
>3. If there is no table with FK references, what do you suggest
>as a solution to our problem ? :
>
>
>
>
>
>
>
Received on Sun Oct 05 1997 - 00:00:00 CDT