DanBrother的部落格

Script for Purging All Tables in th Recyclebin:


set serveroutput on size 1000000
declare
v_purge_text varchar2(1000);
begin
for rec in (select owner,object_name from dba_recyclebin where type = 'TABLE') loop
v_purge_text:='purge table '||rec.owner||'."'||rec.object_name||'"';
execute immediate v_purge_text;
dbms_output.put_line(rec.owner||'.'||rec.object_name||' has been purged !');
end loop;
end;
/

SCOTT.BIN$rMuPtFwZQja6sup5mX8bEg==$0 has been purged !

ps. Use with caution in th production environment.