begin
for f in (select table_name from user_tables) loop
execute immediate 'drop table "'||f.table_name||'" cascade constraints';
end loop;
for f in (select object_type, object_name from user_objects
where object_type in ('SEQUENCE','VIEW','FUNCTION','PROCEDURE','PACKAGE','SYNONYM','DATABASE LINK')) loop
execute immediate 'drop '||f.object_type||' "'||f.object_name||'"';
end loop;
for f in (select type_name from user_types) loop
execute immediate 'drop type "'||f.type_name||'" force';
end loop;
end;
/