set heading off
set pagesize 0
set feedback off
set timing off
set time off
set trimspool on
set trimout on
set linesize 100
set echo off
spool t
select 'drop '||object_type||' '||object_name||
       decode(object_type,'CLUSTER',' including tables cascade constraints',
                          'TABLE',' cascade constraints',
                          '')||';'
from user_objects
where object_type in ('CLUSTER','CONTEXT','DATABASE LINK','DIMENSION',
                      'DIRECTORY','FUNCTION','INDEX TYPE',
                      'JAVA','LIBRARY','MATERIALIZED VIEW','OPERATOR',
                      'OUTLINE','PACKAGE','PROCEDURE','SEQUENCE',
                      'SYNONYM','TABLE','TYPE','VIEW')
order by object_type, object_name
/
spool off
@t.lst