Ora 29902 Error Executing Odciindexstart Routine When Creating Spatial Index With St_geometry
Description Patterns in Oracle (approximately 24 characters or larger) attempting to create a spatial index using st_geometry may result in the following Oracle errors: Code: ORA-29902: error in executing ODCIIndexStart() routine ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at 'SDE.ST_DOMAIN_METHODS', line 125. When creating a spatial index through ArcGIS, errors can also appear in sde_ .log with details enabled. For example, a pattern named FACILITIES_MANAGEMENT_DEPT (user name with data) encountered the above error message when creating a st_geometry spatial index. An index has been created, but problems can cause problems when displaying, querying, and identifying features. the reason In the sde.st_domain_methods package, the ODCIIndexStart function has a variable string defined as 32 characters, which is not sufficient to support schema names and spatial index names of more than 24 characters. Solution Use schema names with fewer characters or query data without spatial indexes (since each spatial query results in a full table scan, you will experience performance issues with large tables).