This discussion is archived
8 Replies Latest reply: Sep 13, 2011 2:20 AM by Anne-Marie Rosa RSS

ORA-13249: Error initializing geodetic transform

Anne-Marie Rosa Newbie
Currently Being Moderated
RDBMS 10.2.0.2
Database NLS_NUMERIC_CHARACTERS ',.'

On a customer site we are getting the error below when we are trying to create an spatial index. On our own database 10.2.0.4 and DB nls_numeric_characters '.,' we do not have any problems creating the index.

SQL> create index geo_punkt2d_i
2 on geodaten (GEO_PUNKT2D)
3 indextype is mdsys.spatial_index
4 PARAMETERS('tablespace=ABM_INDX_L')
5 /
create index geo_punkt2d_i
*
FEHLER in Zeile 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-13249: internal error in Spatial index: [mdidxrbd]
ORA-13249: Error initializing geodetic transform
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 10

In the sdo_geom_metadata table is the following entry

"ABM";"GEODATEN";"GEO_PUNKT2D";"((X; -180; 180; 0,05); (y; -90;90; 0,05); ; )";4326

There is a bug in Metalink (5117577) which is related to this old DB Version but I cannot see any relation to my problem.
The error might have something to do with the setting of nls_numeric_characters (,.), but I do not know, what the create index might have to do with that.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points