Gather Stats fails with ORA-20000: index or partition of such index is in unusable state (Doc ID 1245955.1)

Last updated on JANUARY 12, 2016

Applies to:

Oracle EBS Applications Performance - Version 11.5.10.2 to 12.0.3 [Release 11.5.10 to 12.0]
Information in this document applies to any platform.

Symptoms

Gather Schema Statistics or Gather Table Statistics concurrent programs or running fnd_stats from the command line fails with

ORA-20000: index or partition of such index is in unusable state

Example:

Error #1: ERROR: While GATHER_TABLE_STATS:
object_name=PJI.PJI_PA_PROJ_EVENTS_LOG***ORA-20000: index "PJI"."PJI_PA_PROJ_EVENTS_LOG_N1" or partition of such index is in unusable state***

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