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.查看外键表是否含有相关字段内容;
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.查看外键表是否含有相关字段内容;
- ORA-02291: integrity constraint (INFORES_GZ_PJ2.FK_TC_DEV_PROPERTY_GRP_PROID) violated - parent key
- ORA-02291: integrity constraint: parent key not found
- java.sql.SQLException: ORA-02291: integrity constraint violated - par
- ORA-02291: integrity constraint (SYSTEM.FK1170E5C5328E4352) violated 解决办法
- ORA-02292:integrity constraint(xx) violated
- ORA-02292: integrity constraint (BLDBANK.F_YXDH) violated - child record found
- ORA-02292:integrity constraint(xx) violated - child record found 外键关联,无法删除记录
- java.sql.BatchUpdateException: ORA-02291: integrity constraint
- ORA-00001: unique constraint (.......) violated
- ORA-00001 unique constraint (string.string) violated
- ORA-00001: unique constraint (XINNET20100422.PK_T_THEME_ORDER) violated
- ORA-00001: unique constraint (...) violated解决方案
- ORA-00001: unique constraint (CONTRACT_MGR.PK_T_SUPPLIER) violated
- ORA-02291:parent key not found
- Statspack ORA-00001 unique constraint violated错误的解决
- ORA-00001 unique constraint violated错误的解决
- ORA-00001 unique constraint violated错误的解决 (
- ORA-00001: unique constraint violated并不一定是主键冲突
- Nslookup命令详解 --来源于网络
- 个人所得税法
- iPhone开发私有API是用还是不用
- IEEE 802.1x中的EAPOL
- SSH的xml文件的classpath的使用
- ORA-02291: integrity constraint (INFORES_GZ_PJ2.FK_TC_DEV_PROPERTY_GRP_PROID) violated - parent key
- 分布式文件系统设计主要关注几个方面
- 如何使用Oracle SQLDeveloper 中连接MS SQLServer和MySQL数据库
- Android之模拟器操作
- JSONObject, JSONArray来构建json文本
- CRegKey类来操作注册表
- ubuntu在更新的时候报动态 MMap 没有空间了的问题解决
- 个体工商户条例
- Mybatis小试CRUD