we are migrating our database from Oracle10g to Oracle11g.
for displaying the spatial data we are using an ArcSDE-Service
which also was updated from ArcSDE9.2 to ArcSDE9.3.
at first glance all seemed to work, but then we found out
that we could not query 3 or 4 dimensional layer anymore.
the error is
ORA-29902: Fehler bei der Ausführung von Routine ODCIIndexStart()
ORA-13243: Angegebener Operator wird für 3-dimensionalen oder höher-dimensionalen R-Baum nicht unterstützt
ORA-06512: in "MDSYS.SDO_INDEX_METHOD_10I", Zeile 333
probably that is
ORA-29902: error in executing ODCIIndexStart() routine
ORA-13243: specified operator is not supported for 3- or higher -dimensional R-tree
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 416
the probem is, that the column has a 2-dimensional index
where the layer is defined as "sl3+M" (using sdelayer for registration).
the error disappears when the layer is registered as "sl+"
but then I cannot display hatches
the error also disappears when I change the index to 4-dimensional
but then I get the error in the other applications that assume a 2-dimensional index.
(bwt: there was no problem with ArcSDE9.2 for Oracle10g. here
the 2-dimensional index worked well)
is there a way in ArcSDE9.3/Oracle11g to give SDE a hint to make all queries
with 2-dimensional geometries even if the layers are defined as "sl3+M"?
thanks
Peter
