Oracle Loading DIM=2 with 3D geometries.

[warmerdam]

1
2
3
4
5
6
7
8
9
10
11
12



red@seitzr > ogr2ogr.exe -f OCI OCI:userid/passwd@englink_staging -nln usbr_dams
-lco OVERWRITE=YES -lco DIM=2 -lco SRID=8307 damsgeo.shp
ERROR 1: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-13249: internal error in Spatial index: [mdidxrbd]
ORA-13249: Error in Spatial index: index build failed
ORA-13249: Error in spatial index: [mdrcrtxfergm]
ORA-13249: Error in spatial index: [mdpridxtxfergm]
ORA-13200: internal error [ROWID:AAAPjuAAeAABNKiAAA] in spatial indexing.
ORA-13206: internal error [] while creating the spatial index
ORA-13364: Layer Dimensionality does not match geometry dimensions
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_9I", line 7
ORA-06512: at line 1
 in CREATE INDEX "USBR_DAMS_IDX" ON USBR_DAMS("ORA_GEOMETRY") INDEXTYPE IS
MDSYS.SPATIAL_INDEX

The problem seems to be that the layer type is forced to 2D by the DIM=2, but 
3D geometries are still produced.

[warmerdam]

I was unable to reproduce this loading S-57 SOUNDG data, and forcing the 2D. 
The indexing seemed to work fine.  

It may be related to other geometry types (ie. lines, polygons). 

[mloskot]

Frank,

Should I append this ticket to my Oracle queue and reassign to myself?

[Nicolas Simon]

Hello,

I think you should consider the code I sumit with the problem #1960. It will probably also resolve this problem.

Nicolas

[ilucena]

That was fixed on ticket #1960.