Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle-spatial_idx.sql @ 5377:a5f5599f6fd5 2.9.14
merge
| author | Bettina Gruenbauer <bettina@intevation.de> |
|---|---|
| date | Fri, 22 Mar 2013 11:02:08 +0100 |
| parents | 7b35f2c070c3 |
| children | 8b29a94ebdd8 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-spatial_idx.sql Fri Mar 22 11:01:31 2013 +0100 +++ b/flys-backend/doc/schema/oracle-spatial_idx.sql Fri Mar 22 11:02:08 2013 +0100 @@ -1,12 +1,8 @@ --- TODO: index prevents `DELETE FROM rivers' on 11g --- Error: "Ebenendimensionalitat stimmt nicht mit Geometrie-Dimensionen uberein" --- CREATE INDEX river_axes_km_spatial_idx ON river_axes_km(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=point'); +CREATE INDEX river_axes_km_spatial_idx ON river_axes_km(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=point'); CREATE INDEX buildings_spatial_idx ON buildings(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE'); --- TODO: index prevents `DELETE FROM rivers' on 11g --- Error: "Ebenendimensionalitat stimmt nicht mit Geometrie-Dimensionen uberein" --- CREATE INDEX fixpoints_spatial_idx ON fixpoints(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=POINT'); +CREATE INDEX fixpoints_spatial_idx ON fixpoints(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=POINT'); CREATE INDEX river_axes_spatial_idx ON river_axes(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=MULTILINE');