Last updated on FEBRUARY 08, 2017
Applies to:Oracle Text - Version 22.214.171.124 and later
Information in this document applies to any platform.
Upgraded the database to 12c and after that job which rebuilds the text index is failing with below errors -
alter index TR_ADM.CCSF_CMNT_TXTIDX rebuild partition CCSF_PART_2015Q2 parameters ('SYNC')
ERROR at line 1:
ORA-29874: warning in the execution of ODCIINDEXALTER routine
ORA-29960: line 1,
DRG-10595: ALTER INDEX CCSF_CMNT_TXTIDX failed
DRG-11000: invalid keyword SYNC
ORA-06512: at "TR_BAT.SYNC_TREAD_TXT_IDX", line 13
ORA-06512: at line 1
It was working before upgarde to 12c. Oracle Text is valid in DBA registry.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms