Description:
This article explains how to fix the error ORA-20000: index "EHEALTH"."NH_GROUP_ALL_MEMBERS_AS1_IX5" or partition.
This error can appear in the Statistics Index log like in this example:
Begin processing 11/20/2012 12:20:01 PM.
Error: Sql Error occurred during operation dbuAnalyzeSchemaStats
(ORA-20000: index "EHEALTH"."NH_GROUP_ALL_MEMBERS_AS1_IX5" or partitio).
End processing 11/20/2012 12:20:13 PM.
Scheduled Job ended at '11/20/2012 12:20:13 PM'.
Solution:
The solution is to run a query to rebuild the index.