If you need to drop all tables in the database with Oracle, here’s an easy way!

 

run this command:

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

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