ora-02449

提示：

ORA-02449:unique/primary keys in table referenced by foreign keys.

由于唯一/主键被其他外键引用

原因：

select owner,constraint_name,constraint_type,table_name,status from dba_constraints where owner='SCOTT'

OWNER  CONSTRAINT_NAME       C TABLE_ STATUS

------ ------------------------------ - ------ --------

SCOTT  FK_DEPTNO                      R EMP    ENABLED

SCOTT  PK_DEPT                           P DEPT   ENABLED

SCOTT  PK_EMP                            P EMP    ENABLED

alter table scott.emp drop constraint fk_deptno;