Home » Server Options » Spatial » error while updating SRID to null (oracle11g,windows xp)
error while updating SRID to null [message #515997] Thu, 14 July 2011 07:38 Go to next message
swapnabpnn
Messages: 96
Registered: December 2010
Member
Hi,
I am trying to update SRID of a table from 8307 value to NULL.BUt it is throwing following error.
SQL> update CABLE a set a.geom.sdo_srid=null;
update CABLE a set a.geom.sdo_srid=null
*
ERROR at line 1:
ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine
ORA-13365: layer SRID does not match geometry SRID
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 270


But I tried by keeping in user_sdo_geom_metadata the SRID of cable as 8307.Still it is throwing error as above.

Also I tried by keeping in user_sdo_geom_metadata the SRID of cable as null also.Still it is throwing error as above.


How can I solve this problem.

Re: error while updating SRID to null [message #516015 is a reply to message #515997] Thu, 14 July 2011 09:26 Go to previous message
_jum
Messages: 488
Registered: February 2008
Senior Member
Try to recreate (DROP, change SRID and CREATE) the spatial index on table CABLE.

[Updated on: Thu, 14 July 2011 09:27]

Report message to a moderator

Previous Topic: shifting of coordiantes by adding offset value
Next Topic: Problem when Loading ESRI Shapefiles into Spatial
Goto Forum:
  


Current Time: Thu Jul 31 09:24:33 CDT 2014

Total time taken to generate the page: 0.08846 seconds