删除某用户下的所有对象或者某类对象

删除某用户下所有对象：
select OBJECT_NAME,OBJECT_TYPE,CREATED,LAST_DDL_TIME  from user_objects order by 2 ;

select 'drop '|| OBJECT_TYPE ||' ' || OBJECT_NAME || ' ;' from user_objects  where to_char(LAST_DDL_TIME,'yyyy-mm-dd')>='2013-01-10' ;

select 'drop '|| OBJECT_TYPE ||' ' || OBJECT_NAME || ' ;' from user_objects where OBJECT_TYPE='TABLE'   ;