Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How can I get a list of referenced keys?

How can I get a list of referenced keys?

From: - haven - <haven_at_havenskys.com>
Date: Fri, 12 Jun 1998 20:19:14 GMT
Message-ID: <35818C6E.FDF1F7F7@havenskys.com> 





I need to get drop this table.  How can I get a list of referenced keys?



So that I can drop it.  I disabled all constraints that refer to it but
no dice.


Thanks



Haven




SQL> drop table emp_head;


drop table emp_head


           *


ERROR at line 1:


ORA-02266: unique/primary keys in table referenced by enabled foreign
keys

Received on Fri Jun 12 1998 - 15:19:14 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US