本文共 938 字，大约阅读时间需要 3 分钟。

ORA-02449 ????A?????????????B???????

???????????????ORA-02449 ?????????????unique/primary keys in table referenced by foreign keys????????????????A???????B??????????????????A?????B?????????????????????????????

?????????????????????????????????SQL?????????????

select CONSTRAINT_NAME, TABLE_NAME from dba_constraints where owner = 'SYS' and TABLE_NAME = 'B';

???????B????A???????????????????A????????????????A???????B??????????B???????????????????????????????

??????????????????

ALTER TABLE B ADD CONSTRAINT fk_BA FOREIGN KEY (???) REFERENCES A(???) ON DELETE CASCADE;

3. ??????????????????????????????????????????????????????????????

4. ????????????DBA????Toad?SQL Developer??????????????????????????????

???????????????????????????????????????????????????????

?????????????ORA-02449 ?????????????