Delete all table in the schema with a single command

[jovery]

Run the following

SET HEADING OFF FEEDBACK OFF PAGES 0
SPOOL delete_table.sql
SELECT 'DROP TABLE '||table_name||';'
FROM user_tables;
SPOOL OFF

@delete_table

This is a very simplistic approach and you will probably need to disable any referential constraints.

HTH