如何清空oracle数据库所有表

创建个存储过程来执行啦

在plsql中把以下代码复制粘贴，并运行

create or replace PROCEDURE SP_DROPTABLE
(v_begintime in varchar2,
v_endtime in varchar2)
as
v_tablename varchar2(256);
cursor cur_tablename is
select object_name from user_objects where object_type='TABLE' and to_char(CREATED,'yyyy-mm-dd')
between v_begintime
and v_endtime order by CREATED desc;
begin
open cur_tablename;
loop
fetch cur_tablename into v_tablename;
exit when cur_tablename%notfound;
execute immediate 'drop table '||v_tablename||'';
end loop;
close cur_tablename;
end sp_droptable;

然后，另开一个sql窗口，执行

begin
SP_DROPTABLE('1900-01-01','2013-12-31');
end;