drop all the tables

[aarroyob]

spool /tmp/drop_tables.lst
select 'drop table '||table_name||' cascade;'
from dba_tables
where owner='USERNAME';
spool off

@/tmp/drop_tables.lst

Cheers