Drop em like they're hot

select ‘drop table ‘||table_name||’ cascade constraints;’ from user_tables; Spool the result of this query and execute it.   from:  https://forums.oracle.com/forums/thread.jspa?threadID=614090  ]]>