Script de remise à zéro d'un schéma Oracle

1
Begin
2
for c in (select type_name from user_types) loop
3
execute immediate ('drop type ' || c.type_name || ' force');
4
end loop;
5
End;
6
/
7
Begin
8
for c in (select object_name from user_objects where object_type='TABLE') loop
9
execute immediate ('drop table ' || c.object_name || ' cascade constraints');
10
end loop;
11
End;
12
/
13
Begin
14
for c in (select object_name from user_objects where object_type='VIEW') loop
15
execute immediate ('drop view ' || c.object_name || ' cascade constraints');
16
end loop;
17
End;
18
/
19