Mercurial > dive4elements > river
annotate backend/doc/schema/oracle-drop-spatial.sql @ 9798:e21697ba97f8 3.2.x
Add default configuration in case volume remains unused
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Wed, 15 Nov 2023 11:54:00 +0100 (13 months ago) |
parents | cc53aae06303 |
children |
rev | line source |
---|---|
2862
998f1a7dcfde
New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2861
diff
changeset
|
1 DROP TRIGGER river_axes_trigger; |
6652
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
2 DROP TABLE river_axes PURGE; |
2854
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
3 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'RIVER_AXES'; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
4 DROP SEQUENCE RIVER_AXES_ID_SEQ; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
5 |
2862
998f1a7dcfde
New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2861
diff
changeset
|
6 DROP TRIGGER river_axes_km_trigger; |
6652
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
7 DROP TABLE river_axes_km PURGE; |
2854
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
8 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'RIVER_AXES_KM'; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
9 DROP SEQUENCE RIVER_AXES_KM_ID_SEQ; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
10 |
2862
998f1a7dcfde
New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2861
diff
changeset
|
11 DROP TRIGGER cross_section_tracks_trigger; |
6652
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
12 DROP TABLE cross_section_tracks PURGE; |
2854
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
13 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'CROSS_SECTION_TRACKS'; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
14 DROP SEQUENCE CROSS_SECTION_TRACKS_ID_SEQ; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
15 |
2862
998f1a7dcfde
New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2861
diff
changeset
|
16 DROP TRIGGER buildings_trigger; |
6652
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
17 DROP TABLE buildings PURGE; |
2854
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
18 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'BUILDINGS'; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
19 DROP SEQUENCE BUILDINGS_ID_SEQ; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
20 |
2862
998f1a7dcfde
New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2861
diff
changeset
|
21 DROP TRIGGER fixpoints_trigger; |
6652
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
22 DROP TABLE fixpoints PURGE; |
2854
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
23 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FIXPOINTS'; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
24 DROP SEQUENCE FIXPOINTS_ID_SEQ; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
25 |
2862
998f1a7dcfde
New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2861
diff
changeset
|
26 DROP TRIGGER floodplain_trigger; |
6652
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
27 DROP TABLE floodplain PURGE; |
2854
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
28 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOODPLAIN'; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
29 DROP SEQUENCE FLOODPLAIN_ID_SEQ; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
30 |
2862
998f1a7dcfde
New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2861
diff
changeset
|
31 DROP TRIGGER dem_trigger; |
6652
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
32 DROP TABLE dem PURGE; |
2854
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
33 DROP SEQUENCE DEM_ID_SEQ; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
34 |
5034
96d330bc40d0
Update drop script to include the new tables and leave the old one
Andre Heinecke <aheinecke@intevation.de>
parents:
2862
diff
changeset
|
35 DROP TRIGGER hws_lines_trigger; |
6652
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
36 DROP TABLE hws_lines PURGE; |
5034
96d330bc40d0
Update drop script to include the new tables and leave the old one
Andre Heinecke <aheinecke@intevation.de>
parents:
2862
diff
changeset
|
37 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HWS_LINES'; |
96d330bc40d0
Update drop script to include the new tables and leave the old one
Andre Heinecke <aheinecke@intevation.de>
parents:
2862
diff
changeset
|
38 DROP SEQUENCE HWS_LINES_ID_SEQ; |
96d330bc40d0
Update drop script to include the new tables and leave the old one
Andre Heinecke <aheinecke@intevation.de>
parents:
2862
diff
changeset
|
39 |
96d330bc40d0
Update drop script to include the new tables and leave the old one
Andre Heinecke <aheinecke@intevation.de>
parents:
2862
diff
changeset
|
40 DROP TRIGGER hws_points_trigger; |
6652
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
41 DROP TABLE hws_points PURGE; |
5034
96d330bc40d0
Update drop script to include the new tables and leave the old one
Andre Heinecke <aheinecke@intevation.de>
parents:
2862
diff
changeset
|
42 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HWS_POINTS'; |
96d330bc40d0
Update drop script to include the new tables and leave the old one
Andre Heinecke <aheinecke@intevation.de>
parents:
2862
diff
changeset
|
43 DROP SEQUENCE HWS_POINTS_ID_SEQ; |
2854
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
44 |
2862
998f1a7dcfde
New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2861
diff
changeset
|
45 DROP TRIGGER floodmaps_trigger; |
6652
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
46 DROP TABLE floodmaps PURGE; |
2854
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
47 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOODMAPS'; |
89b097c8ebd7
Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
48 DROP SEQUENCE FLOODMAPS_ID_SEQ; |
2861
b0132e1b9719
Added further shape importers and added the option to reproject shapes during the import process.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2854
diff
changeset
|
49 |
2862
998f1a7dcfde
New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2861
diff
changeset
|
50 DROP TRIGGER hydr_boundaries_trigger; |
6652
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
51 DROP TABLE hydr_boundaries PURGE; |
2862
998f1a7dcfde
New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2861
diff
changeset
|
52 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HYDR_BOUNDARIES'; |
2861
b0132e1b9719
Added further shape importers and added the option to reproject shapes during the import process.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2854
diff
changeset
|
53 DROP SEQUENCE HYDR_BOUNDARIES_ID_SEQ; |
b0132e1b9719
Added further shape importers and added the option to reproject shapes during the import process.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2854
diff
changeset
|
54 |
2862
998f1a7dcfde
New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2861
diff
changeset
|
55 DROP TRIGGER hydr_boundaries_poly_trigger; |
6652
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
56 DROP TABLE hydr_boundaries_poly PURGE; |
2862
998f1a7dcfde
New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2861
diff
changeset
|
57 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HYDR_BOUNDARIES_POLY'; |
2861
b0132e1b9719
Added further shape importers and added the option to reproject shapes during the import process.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2854
diff
changeset
|
58 DROP SEQUENCE HYDR_BOUNDARIES_POLY_ID_SEQ; |
2862
998f1a7dcfde
New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2861
diff
changeset
|
59 |
5409
8b29a94ebdd8
SCHEMA CHANGE: add table for flood marks and missing DROPs for jetties
Tom Gottfried <tom@intevation.de>
parents:
5408
diff
changeset
|
60 DROP TRIGGER jetties_trigger; |
6652
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
61 DROP TABLE jetties PURGE; |
5409
8b29a94ebdd8
SCHEMA CHANGE: add table for flood marks and missing DROPs for jetties
Tom Gottfried <tom@intevation.de>
parents:
5408
diff
changeset
|
62 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'JETTIES'; |
8b29a94ebdd8
SCHEMA CHANGE: add table for flood marks and missing DROPs for jetties
Tom Gottfried <tom@intevation.de>
parents:
5408
diff
changeset
|
63 DROP SEQUENCE JETTIES_ID_SEQ; |
8b29a94ebdd8
SCHEMA CHANGE: add table for flood marks and missing DROPs for jetties
Tom Gottfried <tom@intevation.de>
parents:
5408
diff
changeset
|
64 |
8b29a94ebdd8
SCHEMA CHANGE: add table for flood marks and missing DROPs for jetties
Tom Gottfried <tom@intevation.de>
parents:
5408
diff
changeset
|
65 DROP TRIGGER flood_marks_trigger; |
6652
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
66 DROP TABLE flood_marks PURGE; |
5409
8b29a94ebdd8
SCHEMA CHANGE: add table for flood marks and missing DROPs for jetties
Tom Gottfried <tom@intevation.de>
parents:
5408
diff
changeset
|
67 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOOD_MARKS'; |
8b29a94ebdd8
SCHEMA CHANGE: add table for flood marks and missing DROPs for jetties
Tom Gottfried <tom@intevation.de>
parents:
5408
diff
changeset
|
68 DROP SEQUENCE FLOOD_MARKS_ID_SEQ; |
8b29a94ebdd8
SCHEMA CHANGE: add table for flood marks and missing DROPs for jetties
Tom Gottfried <tom@intevation.de>
parents:
5408
diff
changeset
|
69 |
6652
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
70 DROP TABLE hws_kinds PURGE; |
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
71 DROP TABLE sectie_kinds PURGE; |
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
72 DROP TABLE sobek_kinds PURGE; |
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
73 DROP TABLE fed_states PURGE; |
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
74 DROP TABLE axis_kinds PURGE; |
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
75 DROP TABLE boundary_kinds PURGE; |
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
76 DROP TABLE cross_section_track_kinds PURGE; |
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
77 DROP TABLE floodplain_kinds PURGE; |
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
78 DROP TABLE floodmap_kinds PURGE; |
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
79 DROP TABLE building_kinds PURGE; |
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
80 DROP TABLE jetty_kinds PURGE; |