Ticket #659 (assigned defect)

Opened 4 years ago

Last modified 2 months ago

Oracle Loading DIM=2 with 3D geometries.

Reported by: warmerdam Assigned to: warmerdam (accepted)
Priority: high Milestone:
Component: OGR_SF Version: unspecified
Severity: normal Keywords: oracle oci
Cc:

Description 

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.

Change History

11/10/04 16:23:56 changed by 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).

07/08/08 06:08:53 changed by mloskot

  • keywords set to oracle oci.

07/08/08 06:10:29 changed by mloskot

Frank,

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