Suppression des objets pour un schéma

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;

/