Drop all tables in a tablespace

select ‘drop table ‘, table_name, ‘cascade constraints \;’ from user_tables;