Oracle Spatial Error ORA-29903: error in executing ODCIIndexFetch() routine

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 !

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s