摘要： 1、select 'Drop table '||table_name||';' from all_tables where owner='要删除的用户名（注意要大写）';2、删除所有表以用户test为例for example:declarecursor cur1 is select table_name from dba_tables where owner='TEST';begin for cur2 in cur1 loop execute immediate 'drop table test.'||cur2.t 阅读全文