oracle DROP all objects


set heading off
set term off
set echo off
set feedback off
set pagesize 0
spool AllObjectsDrop.sql
SELECT 'DROP DATABASE LINK ' || OBJECT_NAME || ';' FROM USER_OBJECTS WHERE OBJECT_TYPE = 'DATABASE LINK';
SELECT 'DROP TYPE ' || OBJECT_NAME || ';' FROM USER_OBJECTS WHERE OBJECT_TYPE = 'TYPE';
SELECT 'DROP TRIGGER ' || OBJECT_NAME || ';' FROM USER_OBJECTS WHERE OBJECT_TYPE = 'TRIGGER';
select 'drop view '||view_name||';' from user_views;
select 'drop sequence '||sequence_name|| ';'from user_sequences;
select 'DROP MATERIALIZED VIEW ' || MVIEW_NAME || ';' FROM user_mviews;
select 'drop table '||table_name|| ';'from user_tables;
select 'drop procedure '||OBJECT_NAME|| ';'from USER_OBJECTS where OBJECT_TYPE = 'PROCEDURE';
select 'drop function '||OBJECT_NAME|| ';'from USER_OBJECTS where OBJECT_TYPE = 'FUNCTION';
select 'drop package '||OBJECT_NAME|| ';'from USER_OBJECTS where OBJECT_TYPE = 'package';
select 'drop synonym '||OBJECT_NAME||';' from USER_OBJECTS where OBJECT_TYPE = 'SYNONYM';
spool off