OATM INDEX MIGRATION FAILS WITH ORA-29874, DRG-10595, DRG-10550 (Doc ID 416817.1)

Last updated on JANUARY 23, 2017

Applies to:

Oracle Application Object Library - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
***Checked for relevance on 20-Nov-2013***

Symptoms

Moving indexes with OATM failed with errors like:

ALTER INDEX "HR"."PER_EMPDIR_PEOPLE_N1" REBUILD parameters ('replace storage &&1 .TXN_IND_STORAGE_PREF')

ORA-29874: warning in the execution of ODCIINDEXALTER routine
ORA-29960: line 1,
DRG-10595: ALTER INDEX PER_EMPDIR_PEOPLE_N1 failed
DRG-10550: illegal syntax for index, preference, source or section name
ORA-931: missing identifier

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