After upgrading an Oracle database from 12cR1 to 19c release, this database using Oracle Spatial component. The developers noticed many of their spatial queries are failing and the following error is thrown:
ORA-29903: error in executing ODCIIndexFetch() routine
What is the cause of this issue ?
check the value of this parameter ” SPATIAL_VECTOR_ACCELERATION ” in your database
SQL> show parameter SPATIAL_VECTOR_ACCELERATION
if its set to “FALSE” , then enable it to “TRUE”
SQL> ALTER SYSTEM SET SPATIAL_VECTOR_ACCELERATION = TRUE;
And this will fix the problem. I was under the impression that ” SPATIAL_VECTOR_ACCELERATION” parameter is “optional” parameter that will improve your queries against GIS data, but it seems starting with Oracle 12cR2 and beyond this parameter should be set to TRUE !