Alter Index Rebuild .. SYNC Fails with DRG-11000: invalid keyword SYNC Error after Upgrade to 12c (Doc ID 2040017.1)

Last updated on FEBRUARY 08, 2017

Applies to:

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

Symptoms

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 :
*
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.

Cause

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 hundreds of Community platforms