ORA-02291: integrity constraint (INFORES_GZ_PJ2.FK_TC_DEV_PROPERTY_GRP_PROID) violated - parent key

来源:互联网 发布:淘宝店铺定位怎么写 编辑:程序博客网 时间:2024/05/21 04:01
一.思路1
1.select * from dba_constraints
where owner='INFORES_GZ_PJ2'
AND CONSTRAINT_NAME='FK_TC_DEV_PROPERTY_GRP_PROID'

2.SELECT * FROM DBA_SEGMENTS
WHERE SEGMENT_NAME='TC_DEV_PROPERTY_GRP'
AND OWNER='INFORES_GZ_PJ2'
3.用PL/SQL DEVELOPER查看表的索引或约束字段
3.1使用包查看set long 10000
select dbms_metadata.get_ddl('TABLE','TABLE_NAME','OWNER') FROM DUAL;
4.查看外键表是否含有相关字段内容;