oracle > ORA-02292: integrity constraint (FKD5D2741393F8F5AA) violated - child record found
oracle 在删除的时候报外键错误,找到子记录通过sql找出子记录表SELECT A.CONSTRAINT_NAME,A.TABLE_NAME,A.COLUMN_NAME,B.CONSTRAINT_TYPEFROM USER_CONS_COLUMNS A, USER_CONSTRAINTS B WHERE A.CONSTRAINT_NAME =B.CONSTRAINT_NAME AND a.constraint_name LIKE '%FKD5D2741393F8F5AA%';...
原创
2021-06-10 15:18:54 ·
701 阅读 ·
0 评论