SET ECHO OFF
SET FEEDBACK OFF
SET PAGESIZE 0

SPOOL dropall-command.sql

SELECT 'drop table ' || table_name || ' cascade constraints;'
  FROM user_tables;
SPOOL OFF

START dropall-command

! rm dropall-command.sql

SET PAGESIZE 24
SET FEEDBACK ON
