Dropping everything from an Oracle database

set feedback off

set pagesize 0

spool AllObjectsDrop.sql

select 'drop view '||view_name||';' from user_views;

select distinct 'drop sequence '||sequence_name|| ';'from user_sequences;

select distinct 'drop table '||table_name|| ';'from user_tables;

select distinct 'drop procedure '||name|| ';'from user_source where type = 'procedure';

select distinct 'drop function '||name|| ';'from user_source where type = 'function';

select distinct 'drop package '||name|| ';'from user_source where type = 'package';

select 'drop synonym '||synonym_name||';' from user_synonyms where synonym_name not like 'sta%' and synonym_name like 's_%'

spool off