I’ve come to this site while gooling around for generating drop tables statement in Oracle. Thanks.

As for my future reference, I will write those SQL statement in my post.

select 'drop table '||table_name||' CASCADE CONSTRAINTS;' from USER_TABLES where table_name like '%_XXX%'

Happy SQL-ing !

p/s: Is there anyone know about replication in oracle ?? it gives me headache !! grrrrrr