查看用户的所有对象
select uo.object_name,uo.object_type from user_objects uo where uo.object_type<>'LOB' order by uo.object_type desc
生成删除表的sql语句
select 'drop table '||uo.object_name||';' from user_objects uo where uo.object_type='TABLE' order by uo.object_type desc;
参考文章:
http://www.cnblogs.com/chshnan/archive/2012/02/07/2341694.html