truncate and delete 的另一个区别

最新推荐文章于 2021-08-31 10:50:58 发布

henrybai

最新推荐文章于 2021-08-31 10:50:58 发布

阅读量461

点赞数

CC 4.0 BY-SA版权

文章标签： delete table sql

本文链接：https://blog.youkuaiyun.com/henrybai/article/details/4001577

本文记录了在Oracle数据库中使用SQL语句进行数据删除操作时遇到的外键约束问题及解决方法。尝试直接删除表中的记录时，由于存在外键约束而失败；采用截断表的方式同样因外键约束而无法完成。最终通过先删除子表数据再删除父表数据的方式成功解决了问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SQL> delete from dept;
delete from dept
*
ERROR at line 1:
ORA-02292: integrity constraint (SCOTT.FK_DEPTNO) violated - child record found

SQL> truncate table dept;
truncate table dept
*
ERROR at line 1:
ORA-02266: unique/primary keys in table referenced by enabled foreign keys

SQL> delete from emp;

14 rows deleted.

SQL> delete from dept;

4 rows deleted.

SQL> rollback;

Rollback complete.

SQL> truncate table emp;

Table truncated.

SQL> truncate table dept;
truncate table dept
*
ERROR at line 1:
ORA-02266: unique/primary keys in table referenced by enabled foreign keys