Set linesize 100
Set pagesize 0
set head off feedback off verify off termout off Timing off time off
Spool temp_drop.tmp
Prompt spool drop_all.log
Select Rtrim(
    'drop ' ||object_type||' '||
        object_name||decode(object_type,'TABLE',' cascade constraints ')
        || ';' )
  from user_objects
 Order by object_name
/
Prompt Spool off
Spool off
@temp_drop.tmp
set pagesize 14
Set head on feedback on verify on termout on
exit