changeset 5322:81ad2c717b9c

SCHEMA CHANGE: added spatial index for river_axes in Oracle
author Tom Gottfried <tom@intevation.de>
date Fri, 15 Mar 2013 17:19:16 +0100
parents 6dd354e7abfc
children c7ce7c9e405e
files flys-backend/doc/schema/oracle-spatial_idx.sql
diffstat 1 files changed, 1 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-spatial_idx.sql	Fri Mar 15 16:43:00 2013 +0100
+++ b/flys-backend/doc/schema/oracle-spatial_idx.sql	Fri Mar 15 17:19:16 2013 +0100
@@ -10,9 +10,7 @@
 -- 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');
 
--- TODO: index prevents importing on 11g.
--- Error: "Ebenendimensionalitat stimmt nicht mit Geometrie-Dimensionen uberein"
--- CREATE INDEX river_axes_spatial_idx ON river_axes(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=MULTILINE');
+CREATE INDEX river_axes_spatial_idx ON river_axes(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=MULTILINE');
 
 -- TODO: index prevents importing on 11g.
 -- Error: "Ebenendimensionalitat stimmt nicht mit Geometrie-Dimensionen uberein"

http://dive4elements.wald.intevation.org