寫一個(gè)循環(huán)刪除的過(guò)程。 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 方法雖好，但我應(yīng)用在一個(gè)億級(jí)數(shù)據(jù)庫(kù)時(shí)還是覺得慢得不行。就算刪一點(diǎn)點(diǎn)數(shù)據(jù)也覺得好象挺慢的。
