0 Replies Latest reply on Apr 21, 2014 10:22 AM by user13780543

    Error while using the Optimize_index

    user13780543

      Hi,

       

      We are trying to use the Optimize_index option with OPTLEVEL=>'FULL' and degree as 2, and getting the below error messages,

       

      Error : 1)

       

      ORA-20000: Oracle Text error:
      DRG-50857: oracle error in drvddl.IndexOptimizePar
      ORA-12801: error signaled in parallel query server P001, instance
      ORA-20000: Oracle Text error:
      DRG-11341: Index optimization failed for one or more tokens

      ORA-06512: at "CTXSYS.DRUE", line 160
      ORA-06512: at "CTXSYS.DRVPARX", line 77
      ORA-06512: at "CTXSYS.DRUE", line 160
      ORA-06512: at "CTXSYS.CTX_DDL", line 1042
      ORA-06512: at line 2

       

      Error : 2)

       

      ORA-20000: Oracle Text error:
      DRG-50857: oracle error in drvddl.IndexOptimizePar
      ORA-12801: error signaled in parallel query server P001, instance
      ORA-20000: Oracle Text error:
      DRG-50857: oracle error in dreogHandleTokenErrors
      ORA-22165: given index [32767] must be in the range of [0] to [32766]


      ORA-06512: at "CTXSYS.DRUE", line 160
      ORA-06512: at "CTXSYS.DRVPARX", line 77
      ORA-06512: at "CTXSYS.DRUE", line 160
      ORA-06512: at "CTXSYS.CTX_DDL", line 1042
      ORA-06512: at line 2

       

      Please help us to resolve the issue.