Tool:PL/SQL developer
Syntax:SELECT 'DROP TABLE ' || table_name || ';' FROM user_tables;
1.then you can copy select result in command widows.
2.you can export select result and editor script import database.
weblink:https://stackoverflow.com/questions/26968999/oracle-drop-multiple-table-in-a-single-query
