My Oracle Support Banner

Error During The Text Index (Doc ID 2444310.1)

Last updated on SEPTEMBER 27, 2018

Applies to:

Oracle Text - Version and later
Information in this document applies to any platform.


Getting an invalid rowid error when running an Oracle Text query and unable to fetch data.

select count(*) from application app where app.app_key in (select app.app_key from application app where contains(app.app_data, 'BAS%')>0 ) and ((app.APP_DECISION_CODE = 7)) ;

ORA-29903: error in executing ODCIIndexFetch() routine
ORA-01410: invalid ROWID
29903. 00000 - "error in executing ODCIIndexFetch() routine"
*Cause: The execution of ODCIIndexFetch routine caused an error.
*Action: Examine the error messages produced by the indextype code and
  take appropriate action.

Dropping and recreating the Oracle Text index eliminates the error.





To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.