3: declare
4: stmt varchar2(200);
5: cnt number;
6: BEGIN
7: if sys.dbms_standard.dictionary_obj_type = 'USER' THEN
8: stmt := 'DELETE FROM SDO_GEOM_METADATA_TABLE ' ||
9: ' WHERE SDO_OWNER = :owner ';
10: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
11:
6: BEGIN
7: if sys.dbms_standard.dictionary_obj_type = 'USER' THEN
8: stmt := 'DELETE FROM SDO_GEOM_METADATA_TABLE ' ||
9: ' WHERE SDO_OWNER = :owner ';
10: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
11:
12: stmt := 'DELETE FROM SDO_MAPS_TABLE ' ||
13: ' WHERE SDO_OWNER = :owner ';
14: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
10: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
11:
12: stmt := 'DELETE FROM SDO_MAPS_TABLE ' ||
13: ' WHERE SDO_OWNER = :owner ';
14: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
15:
16: stmt := 'DELETE FROM SDO_CACHED_MAPS_TABLE ' ||
17: ' WHERE SDO_OWNER = :owner ';
18: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
14: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
15:
16: stmt := 'DELETE FROM SDO_CACHED_MAPS_TABLE ' ||
17: ' WHERE SDO_OWNER = :owner ';
18: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
19:
20: stmt := 'DELETE FROM SDO_STYLES_TABLE ' ||
21: ' WHERE SDO_OWNER = :owner ';
22: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
18: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
19:
20: stmt := 'DELETE FROM SDO_STYLES_TABLE ' ||
21: ' WHERE SDO_OWNER = :owner ';
22: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
23:
24: stmt := 'DELETE FROM SDO_THEMES_TABLE ' ||
25: ' WHERE SDO_OWNER = :owner ';
26: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
22: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
23:
24: stmt := 'DELETE FROM SDO_THEMES_TABLE ' ||
25: ' WHERE SDO_OWNER = :owner ';
26: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
27:
28: stmt := 'DELETE FROM SDO_LRS_METADATA_TABLE ' ||
29: ' WHERE SDO_OWNER = :owner ';
30: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
26: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
27:
28: stmt := 'DELETE FROM SDO_LRS_METADATA_TABLE ' ||
29: ' WHERE SDO_OWNER = :owner ';
30: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
31:
32: stmt := 'DELETE FROM SDO_TOPO_METADATA_TABLE ' ||
33: ' WHERE SDO_OWNER = :owner ';
34: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
30: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
31:
32: stmt := 'DELETE FROM SDO_TOPO_METADATA_TABLE ' ||
33: ' WHERE SDO_OWNER = :owner ';
34: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
35:
36: stmt := 'DELETE FROM SDO_ANNOTATION_TEXT_METADATA ' ||
37: ' WHERE F_TABLE_SCHEMA = :owner ';
38: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
34: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
35:
36: stmt := 'DELETE FROM SDO_ANNOTATION_TEXT_METADATA ' ||
37: ' WHERE F_TABLE_SCHEMA = :owner ';
38: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
39: end if;
40: end;