Topobase

Reply
New Member
LevonVardanyan
Posts: 1
Registered: ‎03-14-2008
Message 1 of 2 (176 Views)

SDO Geometry

176 Views, 1 Replies
03-14-2008 03:00 AM
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
Contributor
Arnab Ganguly
Posts: 11
Registered: ‎01-26-2007
Message 2 of 2 (176 Views)

Re: SDO Geometry

03-26-2008 10:56 AM in reply to: LevonVardanyan
Hi there

Could it be that the SDO geometry that you are trying to insert is 3D (i.e. has a Z value) and the default index in Topobase 2008 is for 2D geometry data?

Update WA_LINE set GEOM =mdsys.sdo_geometry(2002,null,null,mdsys.sdo_elem_info_array(1,2,1),mdsys.sdo_o rdinate_array(3485804.528,5542216.597,3485803.779,5542216.018,3485801.333,55 42197.221)) where FID = ' 9940099'

Try this instead to see if it makes a difference?

Regards

Arnab

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community