8 Replies Latest reply on Sep 13, 2011 9:20 AM by Frieda

    ORA-13249: Error initializing geodetic transform

      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 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.