Hi,
I'm checking the new OCM Advanced Update 16 in combination with Oracle 19c and 3-dimensional data.
Data consists of simple lines, has a valid 3d spatial index and is listed in user_sdo_geom_metadata.
I created a project in Geospatial Administrator, registered a feature, created a workspace an tried to extract data in OpenCities Map.
That's working fine as long as I'm not querying by fence or view. In these cases it throws:
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 671
I guess the operator is: WHERE SDO_ANYINTERACT ( SDOGIS.HOEHENLINIEN_SDO.OGC_GEOMETRY, :1) = 'TRUE'
DesignFile is 3D and I was assuming that the Connector is using the correct 3D operators when querying data.
When I connect to a 12g database it's working fine and I can extract 3d data via fence.
Is anyone else affected by this behavior? Or do I miss anything?
Kind Regards,
Maik
Maik, are you confident that the 19c and 12c spatial indexes are identical? i.e. 2D vs 3D, etc.?
Dan,
we exported 12c and imported in 19c with tables and indizes. I checked and they are 3d, I recreated and also checked on the new spatial index feature MDSYS.SPATIAL_INDEX_V2 but it's still not working.
Index is created like:
Create Index HOEHENLINIEN_SDO_SIDX on HOEHENLINIEN_SDO (OGC_GEOMETRY) INDEXTYPE IS MDSYS.SPATIAL_INDEX PARAMETERS('sdo_indx_dims=3,layer_gtype=curve');
Hello Maik,
I just wanted confirm if your SDO Geometry Metadata has all three element mentioned?
For Example:
INSERT INTO USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID)
VALUES
(
'test',
'G3E_GEOMETRY',
MDSYS.SDO_DIM_ARRAY
MDSYS.SDO_DIM_ELEMENT('X', 0.0, 10000000.0, 0.0005),
MDSYS.SDO_DIM_ELEMENT('Y', 0.0, 10000000.0, 0.0005),
MDSYS.SDO_DIM_ELEMENT('Z', 0.0, 10000.0, 0.0005)
),
NULL
);
Sanket Butala
Hello,
yes, the dataset looks like:
'HOEHENLINIEN_SDO', 'OGC_GEOMETRY', MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('X',4500000,4535000,0.0001),MDSYS.SDO_DIM_ELEMENT('Y',5645000,5690000,0.0001),MDSYS.SDO_DIM_ELEMENT('Z',-1000,1000,0.0001)), null
Removing a comma which was inserted in between index parameters ('sdo_indx_dims=3 layer_gtype=curve'); resolved this issue.
Answer Verified By: Sanket Butala