Getting errors DRG-50857: Oracle Error In Drvddl.Indexcreate ORA-27477 "DR$VAULTTEXT_TEXT$J" Already Exists (Doc ID 1404265.1)

Last updated on FEBRUARY 02, 2012

Applies to:

Oracle Text - Version: 10.1.0.2 to 11.2.0.3 - Release: 10.1 to 11.2
Information in this document applies to any platform.

Symptoms

We started the instance with new ORACLE_HOME and deinstalled existing and re installed Oracle Text.

While creating below index, we are getting below error:

SQL> CREATE INDEX "SYMYXDB"."VAULTTEXT_TEXT" ON "SYMYXDB"."VAULTTEXT" ("TEXT")
INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS ('
 FILTER CTXSYS.AUTO_FILTER
 FORMAT COLUMN format
 CHARSET COLUMN encoding
 SYNC (EVERY "sysdate+(5/1440)")');
CREATE INDEX "SYMYXDB"."VAULTTEXT_TEXT" ON "SYMYXDB"."VAULTTEXT" ("TEXT") INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS
('FILTER CTXSYS.AUTO_FILTER FORMAT COLUMN format CHARSET COLUMN encoding
SYNC (EVERY "sysdate+(5/1440)")')
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drvddl.IndexCreate
ORA-27477: "SYMYXDB.DR$VAULTTEXT_TEXT$J" already exists
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 366

SQL> SELECT index_name, STATUS, DOMIDX_STATUS, DOMIDX_OPSTATUS, ITYP_OWNER, ityp_name
FROM dba_INDEXES WHERE INDEX_TYPE = 'DOMAIN';

INDEX_NAME       STATUS   DOMIDX_STATU DOMIDX ITYP_OWNER      ITYP_NAME
---------------- -------- ------------ ------ --------------- --------------
VAULTTEXT_TEXT   VALID    VALID        FAILED CTXSYS          CONTEXT

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