寫一個循環(huán)刪除的過程。 create or replace procedure delBigTab(p_TableName in varchar2,p_Condition in varchar2,p_Count in varchar2) as pragma autonomous_transaction; n_delete number:=0; begin while 1=1 loop EXECUTE IMMEDIATE 'delete from '||p_TableName||' where '||p_Condition||' and rownum = :10000' USING p_Count; if SQL%NOTFOUND then exit; else n_delete:=n_delete + SQL%ROWCOUNT; end if; commit; end loop; commit; DBMS_OUTPUT.PUT_LINE('Finished!'); DBMS_OUTPUT.PUT_LINE('Totally '||to_char(n_delete)||' records deleted!'); end delBigTab; 調(diào)用： SQL> set timing on SQL> exec delBigTab('HS_DLF_DOWNLOG_HISTORY','NUMDLFLOGGUID 11100000','10000'); PL/SQL procedure successfully completed. Elapsed: 00:00:18.54 方法雖好，但我應用在一個億級數(shù)據(jù)庫時還是覺得慢得不行。就算刪一點點數(shù)據(jù)也覺得好象挺慢的。
