An Easy Way to Drop All of the Tables in Your Tablespace in Oracle

Posted on March 8, 2008 by Devon

run this command:

select 'drop table ', table_name, 'cascade constraints;' from user_tables;

Then copy the output and run that as a sql script.

Devon Hillard's Digital Sanctuary