Easy way to wipe a set of Oracle schemas

Question

How can you wipe a set of Oracle schemas?

By wipe I mean remove all data, tables, views, procedures, synonyms, etc, etc.

Answer 1

Start sqlplus as SYSTEM and then type:

drop user MYSCHEMA cascade;

Repeat for all the schemas that you want to drop.

Answer 2

This is a beginning, not a fully baked script - I'm pretty sure it'll fail if the user has, for example, any queues configured with AQ.

declare
  l_sql varchar2(2000);
begin
  for i in (select object_type, object_name 
              from dba_objects
             where owner = :user_to_be_wiped
               and object_type in ('TYPE', 'PACKAGE', 'PROCEDURE', 'FUNCTION', 
                                   'TABLE', 'VIEW', 'SEQUENCE', 'DATABASE LINK')
  loop
    l_sql := 'drop ' || :user_to_be_wiped || ' ' || i.object_type || '.' i.object_name;
    if i.object_type = 'TABLE' then
      l_sql := l_sql || ' cascade constraints';
    end if;
    execute immediate l_sql;
  end loop;
end;
/