ORA-02292:integrity constraint(xx) violated - child record found 外键关联,无法删除记录
来源:互联网 发布:mac创建acc版本在哪里 编辑:程序博客网 时间:2024/06/16 23:22
经常我们在删除DB记录时,会为外键关联而无法删除数据感到苦恼。这里个人经常用到的一个方法就是,先让关联主键失效,然后再删除数据,数据删除完成后,再让其主
键生效,这样很好的解决了删除级联数据难的问题。
第一步:让主键失效:alter table table_name disable primary key cascade;
第二步:删除数据:delete table_name;
第三步:让主键生效:alter table table_name enable primary key;
- ORA-02292:integrity constraint(xx) violated - child record found 外键关联,无法删除记录
- ORA-02292: integrity constraint (BLDBANK.F_YXDH) violated - child record found
- ORA-02292:integrity constraint(xx) violated
- 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-02292 外键关联,无法删除记录
- ORA-02291: integrity constraint: parent key not found
- 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并不一定是主键冲突
- 命名空间与异常
- ubuntu下tftp server的安装
- Eclipse快捷键大全
- Launcher源码中Intent.createChooser()实现原理及小例子
- 基于Z301P摄像头 H.264OK6410的远程视频web监控 项目笔记5(小车驱动)GPIO控制
- ORA-02292:integrity constraint(xx) violated - child record found 外键关联,无法删除记录
- 学生 残废管理系统(是管理系统残废)喵
- VC中利用MFC设计绘图程序初步
- FreeBSD8.2 Release一个比较快的源
- Oracle中的分页存储过程
- android图片的内存优化
- android apk代码和xml资源文件反编译
- 陀螺仪
- hdu 1856 More is better