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

数据库操作与分析

最新推荐文章于 2024-10-21 10:22:26 发布

最新推荐文章于 2024-10-21 10:22:26 发布 · 276 阅读

一.思路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.查看外键表是否含有相关字段内容；