Oracle drop all tables.

1). get a list of the tables and construct the drop statement.
select 'drop table '|| object_name || ' cascade constraint;' from user_objects where object_type = 'TABLE';


2). run the result.