Re: inability to drop table dur to unknown enables FK

Yochi Wieman wrote:

> <snip>
 

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

You can look in all_constraints(although it wont show constraints that you dont have select on the table for, i know cause i am having problems with it in my drop column package i am writing). If you have dba privilege, you can see them all in sys.dba_constraints,

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

Nope, disabling wont do it, you have to drop them, or do a drop table <table_name> cascade constraints;

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

 see #2 answer.

--
Joseph S. Testa, Oracle Database Administrator
Are you looking for Oracle DBA in Central Ohio, but only want one for
some part-time work? try http://web.scioto.net/jtesta
That is also the place to find the FREE, "how do I build a second,
third, etc, instance, without using oracle's installer, database
scripts.
ICQ UIN: 2814105(Joe-N8XCT, Home) UIN: 2832230(&oracle, work).