Drop All Objects In Schema

SET VERIFY OFF;
SET ECHO OFF;
SET HEADING OFF;
SET PAUSE OFF;
SET TERMOUT OFF;
SET SERVEROUTPUT OFF;
SET FEEDBACK OFF;
SET TRIMOUT   OFF;
SPOOL DeleteAllTables.SQL;

SELECT 'DROP  '||object_type||'  '||object_name||';'  FROM USER_OBJECTS WHERE object_type IN ('VIEW','SYNONYM','PROCEDURE','FUNCTION','PACKAGE','TRIGGER','PACKAGE','SEQUENCE');

SELECT 'DROP  '||object_type||'  '||object_name||' CASCADE CONSTRAINTS;'  FROM USER_OBJECTS WHERE object_type IN ('TABLE');

SPOOL OFF;
@DeleteAllTables.SQL;
COMMIT;
purge recyclebin;
COMMIT;
exit;