本文共 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???????????????????????????????
??????????????????
???A?????????A???????B???????B?????????????????A???????????????????????A???????????????????
???B?????????B??????A???????????B?????????????SQL?????
ALTER TABLE B ADD CONSTRAINT fk_BA FOREIGN KEY (???) REFERENCES A(???) ON DELETE CASCADE;
??????????????????????????????????????????????????????????????
????????????DBA????Toad?SQL Developer??????????????????????????????
???????????????????????????????????????????????????????
?????????????ORA-02449 ?????????????
转载地址：http://jxpfk.baihongyu.com/