Mercurial > dive4elements > river

comparison backend/doc/schema/oracle-drop-minfo.sql @ 6652:765944ca6df0 double-precision

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
author Tom Gottfried <tom@intevation.de>
date Wed, 24 Jul 2013 18:41:22 +0200
parents 97145ec4e33c
children ad614eff7a9b
comparison
equal deleted inserted replaced
6651:8782ba5cb222 6652:765944ca6df0
34 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_river_id; 34 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_river_id;
35 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_range_id; 35 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_range_id;
36 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_reference_gauge_id; 36 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_reference_gauge_id;
37 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_observation_timerange_id; 37 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_observation_timerange_id;
38 38
39 DROP TABLE bed_height_type; 39 DROP TABLE bed_height_type PURGE;
40 DROP TABLE location_system; 40 DROP TABLE location_system PURGE;
41 DROP TABLE elevation_model; 41 DROP TABLE elevation_model PURGE;
42 DROP TABLE bed_height_single; 42 DROP TABLE bed_height_single PURGE;
43 DROP TABLE bed_height_single_values; 43 DROP TABLE bed_height_single_values PURGE;
44 DROP TABLE bed_height_epoch_values; 44 DROP TABLE bed_height_epoch_values PURGE;
45 DROP TABLE bed_height_epoch; 45 DROP TABLE bed_height_epoch PURGE;
46 DROP TABLE depths; 46 DROP TABLE depths PURGE;
47 DROP TABLE sediment_density; 47 DROP TABLE sediment_density PURGE;
48 DROP TABLE sediment_density_values; 48 DROP TABLE sediment_density_values PURGE;
49 DROP TABLE morphologic_width; 49 DROP TABLE morphologic_width PURGE;
50 DROP TABLE morphologic_width_values; 50 DROP TABLE morphologic_width_values PURGE;
51 DROP TABLE discharge_zone; 51 DROP TABLE discharge_zone PURGE;
52 DROP TABLE flow_velocity_model; 52 DROP TABLE flow_velocity_model PURGE;
53 DROP TABLE flow_velocity_model_values; 53 DROP TABLE flow_velocity_model_values PURGE;
54 DROP TABLE flow_velocity_measurements; 54 DROP TABLE flow_velocity_measurements PURGE;
55 DROP TABLE flow_velocity_measure_values; 55 DROP TABLE flow_velocity_measure_values PURGE;
56 DROP TABLE grain_fraction; 56 DROP TABLE grain_fraction PURGE;
57 DROP TABLE sediment_yield; 57 DROP TABLE sediment_yield PURGE;
58 DROP TABLE sediment_yield_values; 58 DROP TABLE sediment_yield_values PURGE;
59 DROP TABLE measurement_station; 59 DROP TABLE measurement_station PURGE;
60 DROP TABLE sq_relation_value; 60 DROP TABLE sq_relation_value PURGE;
61 DROP TABLE sq_relation; 61 DROP TABLE sq_relation PURGE;
62 62
63 DROP SEQUENCE LOCATION_SYSTEM_SEQ; 63 DROP SEQUENCE LOCATION_SYSTEM_SEQ;
64 DROP SEQUENCE ELEVATION_MODEL_SEQ; 64 DROP SEQUENCE ELEVATION_MODEL_SEQ;
65 DROP SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ; 65 DROP SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ;
66 DROP SEQUENCE BED_SINGLE_VALUES_ID_SEQ; 66 DROP SEQUENCE BED_SINGLE_VALUES_ID_SEQ;
http://dive4elements.wald.intevation.org