We have problems with importing SDO geometry from spatial geometry data in oracle 10 to Topobase 2008. With the import we got the message, it doesn't matter if the objects where lines or points:
ERR> Update WA_LINE set GEOM =mdsys.sdo_geometry(3002,null,null,mdsys.sdo_elem_info_array(1,2,1),mdsys.sdo_ordinate_array(3485804.528,5542216.597,0,3485803.779,5542216.018,0,3485801.333,5542197.221,0)) where FID = ' 9940099'
^ERROR
SQL execution error, ORA-29877: ORA-29877: Routine ODCIINDEXUPDATE nicht erfolgreich ausgeführt
ORA-13364: Ebenendimensionalität stimmt nicht mit Geometrie-Dimensionen überein
ORA-06512: in "MDSYS.SDO_INDEX_METHOD_10I", Zeile 243
coordinate system are the same of both database. TB dictionary x + y is set to 10 000 000. The SDO meta data of both oracle dumps are also the same.
Anyone here an idea?
best regards G+B