How to fix ORA-20000: index "EHEALTH"."NH_GROUP_ALL_MEMBERS_AS1_IX5" or partition

Document ID : KB000021151
Last Modified Date : 14/02/2018
Show Technical Document Details

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.

  1. Sign on to sql session as $NHUSER

    sqlplus $NH_USER/$NH_USER

  2. Run the sql below to confirm the existence of NH_GROUP_ALL_MEMBERS_AS1_IX5

    SELECT index_name,partition_name,status
    FROM dba_ind_partitions
    WHERE index_name = NH_GROUP_ALL_MEMBERS_AS1_IX5 ;

  3. Run the sql below to rebuild the index

    ALTER INDEX NH_GROUP_ALL_MEMBERS_AS1_IX5 REBUILD;

  4. Exit from sqlplus

    exit

  5. Rerun the stats index job to see if the error disappears