- select 'drop table '||table_name||' cascade constraints;' from user_tables;
- select 'drop trigger ' || trigger_name || ';' from user_triggers;
- select 'drop sequence ' || sequence_name || ';' from user_sequences;
转自:http://luhantu.iteye.com/blog/2082975