1) drop the user
2) build scripts using dynamic SQL

go to tahiti.oracle.com