Mercurial > dive4elements > river
changeset 5109:357938c64967 dami
added TODOs to spatial indeces that prevent from importing into Oracle 11g
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Wed, 27 Feb 2013 11:17:42 +0100 |
| parents | d16398d65a59 |
| children | ab2f1e0be311 |
| files | flys-backend/doc/schema/oracle-spatial_idx.sql |
| diffstat | 1 files changed, 8 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-spatial_idx.sql Tue Feb 26 19:39:04 2013 +0100 +++ b/flys-backend/doc/schema/oracle-spatial_idx.sql Wed Feb 27 11:17:42 2013 +0100 @@ -1,7 +1,15 @@ CREATE INDEX river_axes_km_spatial_idx ON river_axes_km(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 buildings_spatial_idx ON buildings(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE'); + 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=LINE'); + CREATE INDEX CrossSectionTracks_spatial_idx ON cross_section_tracks(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE'); CREATE INDEX floodplain_spatial_idx ON floodplain(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=POLYGON'); CREATE INDEX hydr_boundaries_idx ON hydr_boundaries(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE');