Delete all User tables in Oracle
2009 April 22
Thanks to "Ramoorthy" on this forum for the following tip:
To drop all the tables(only tables) of a user you can use the following query.
select 'drop table '||table_name||' cascade constraints;' from user_tables;
Spool the result of this query and execute it.
This was a big help!