On 11.2.0.2 CTX_DDL.OPTIMIZE_INDEX fails with an empty ORA-20000 error (Doc ID 1275100.1)

Last updated on JANUARY 09, 2017

Applies to:

Oracle Text - Version 11.2.0.2 to 11.2.0.2 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 08-Jan-2014***

Symptoms

Since upgrade to 11.2.0.2 ctx_ddl.optimize_index fails with an empty error ORA-20000:

BEGIN CTX_DDL.OPTIMIZE_INDEX(idx_name => 'MPZATQUELL_TEXT', optlevel => 'REBUILD'); END;
*
ERROR at line 1:
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drvddl.IndexOptimizeRebuild
ORA-20000: Oracle Text error:
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_DDL", line 941
ORA-06512: at line 1


BEGIN CTX_DDL.OPTIMIZE_INDEX(idx_name => 'MPZATQUELL_TEXT', optlevel => 'FULL'); END;
*
ERROR at line 1:
ORA-20000: Oracle Text error:
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_DDL", line 941
ORA-06512: at line 1


BEGIN CTX_DDL.OPTIMIZE_INDEX(idx_name => 'MPZATQUELL_TEXT', optlevel => 'FAST'); END;
*
ERROR at line 1:
ORA-20000: Oracle Text error:
DRG-10535: failed to optimize text index MPZATQUELL_TEXT
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_DDL", line 941
ORA-06512: at line 1


BEGIN CTX_DDL.OPTIMIZE_INDEX(idx_name => 'MPZATQUELL_TEXT', optlevel => 'TOKEN_TYPE', token => 'Text');END;
*
ERROR at line 1:
ORA-20000: Oracle Text error:
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_DDL", line 941
ORA-06512: at line 1


Same error occurs when trying to rebuild the index with new storage settings.

SQL> alter index MPZATQUELL_TEXT rebuild parameters ('replace storage mystore');
alter index MPZATQUELL_TEXT rebuild parameters ('replace storage mystore')
*
ERROR at line 1:
ORA-29874: warning in the execution of ODCIINDEXALTER routine
ORA-29960: line 1,
DRG-10595: ALTER INDEX MPZATQUELL_TEXT failed
DRG-50857: oracle error in drvddl.IndexOptimizeRebuild
ORA-20000: Oracle Text error:

Changes

Upgraded database to 11.2.0.2

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