delete from table where (你的条件) and rownum<10000; commit; delete from table where (你的条件) and rownum<10000; commit; delete from table where (你的条件) and rownum<10000; commit; delete from table where (你的条件) and rownum<10000; commit; .... ... .. . 重复几次不就OK了
commit;
delete from table where (你的条件) and rownum<10000;
commit;
delete from table where (你的条件) and rownum<10000;
commit;
delete from table where (你的条件) and rownum<10000;
commit;
....
...
..
.
重复几次不就OK了