ORA-02292:integrity constraint(xx) violated
来源:互联网 发布:淘宝优站报名入口 编辑:程序博客网 时间:2024/05/21 01:58
经常我们在删除DB记录时,会为外键关联而无法删除数据感到苦恼。这里个人经常用到的一个方法就是,先让关联主键失效,然后再删除数据,数据删除完成后,再让其主
键生效,这样很好的解决了删除级联数据难的问题。
第一步:让主键失效:alter table table_name disable primary key cascade;
第二步:删除数据:delete table_name;
第三步:让主键生效:alter table table_name enable primary key;
阅读全文
0 0
- ORA-02292:integrity constraint(xx) violated
- ORA-02292:integrity constraint(xx) violated - child record found 外键关联,无法删除记录
- ORA-02292: integrity constraint (BLDBANK.F_YXDH) violated - child record found
- ORA-02291: integrity constraint (INFORES_GZ_PJ2.FK_TC_DEV_PROPERTY_GRP_PROID) violated - parent key
- java.sql.SQLException: ORA-02291: integrity constraint violated - par
- ORA-02291: integrity constraint (SYSTEM.FK1170E5C5328E4352) violated 解决办法
- 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
- java.sql.BatchUpdateException: ORA-02291: integrity constraint
- Statspack ORA-00001 unique constraint violated错误的解决
- ORA-00001 unique constraint violated错误的解决
- ORA-00001 unique constraint violated错误的解决 (
- ORA-00001: unique constraint violated并不一定是主键冲突
- ORA-00001: unique constraint (...) violated并不一定是数据冲突
- ORA-00001: unique constraint (...) violated并不一定是数据冲突
- linux exec函数族
- 理解字节序
- 不用正则,得到url中的HOST,端口,路径,查询参数
- 序列化和反序列化
- iOS备忘录之获取APPStore上的APPID
- ORA-02292:integrity constraint(xx) violated
- [BZOJ4472]-树形&贪心
- Connect函数
- EAS,BOS,校验业务单据是否已经通过BOTP生成指定下游单据
- https原理通俗了解
- Caysn打印机IOS平台打印开发包及示例程序_20170610
- Java数据结构与算法---链表的实现
- Solr安装
- leetcode 118. Pascal's Triangle