我用采集工具spoon采集了多次,然后想删掉数据重新采集,有因为有采集错的地方。
但我发现delete一次不能清空表
SQL> delete from branchbusiness;
10700 rows deleted
SQL> commit;
Commit complete
SQL> delete from branchbusiness;
900 rows deleted
SQL> commit;
Commit complete
SQL> delete from branchbusiness;
5100 rows deleted执行了好多次。我想,spoon也是用Oracle命令的,什么命令可以产生这样的效果啊,point?
但我发现delete一次不能清空表
SQL> delete from branchbusiness;
10700 rows deleted
SQL> commit;
Commit complete
SQL> delete from branchbusiness;
900 rows deleted
SQL> commit;
Commit complete
SQL> delete from branchbusiness;
5100 rows deleted执行了好多次。我想,spoon也是用Oracle命令的,什么命令可以产生这样的效果啊,point?
有可能在你删除完数据之后,其它session有insert了数据!
效率非常高truncate table branchbusiness;