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

原创

于 2016-03-08 14:59:17 发布 · 1.4k 阅读

CC 4.0 BY-SA版权

SQL> truncate table alert_store;
truncate table alert_store
               *
ERROR at line 1:
ORA-02266: unique/primary keys in table referenced by enabled foreign keys

SQL> SET PAGESIZE 1000
SQL> select c1.table_name      as org_table_name,           
  2            c1.constraint_name as org_constraint_name,
  3            c1.constraint_type as org_constriant_type,
  4            n1.column_name     as org_colun_name,     
  5            c2.table_name      as ref_table_name,     
  6            c2.constraint_type as ref_constraint_type,
  7            c2.constraint_name as ref_constraint_name,
  8            n2.column_name     as ref_column_name     
  9       from dba_constraints  c1,                      
 10            dba_constraints  c2,                      
 11            dba_cons_columns n1,                      
 12            dba_cons_columns n2