drop all the tables

Hi all,

I want to drop all the tables in a user in single command. i do not
want to drop user . is it possible. how we can do this.


thanx in adv

spool /tmp/drop_tables.lst
select 'drop table '||table_name||' cascade;'
from dba_tables
where owner='USERNAME';
spool off

@/tmp/drop_tables.lst

Cheers