9 Replies Latest reply: Jun 15, 2012 9:17 AM by 622206 RSS

    Oracle Text Index Error - DRG-10700: preference does not exist: CTXSYS.DEFA

    622206
      Hi we are having a Oracle 11g db.And we have installed CTX SYS package and provided the grants to the required schema.
      But while creating the oracle text index, following error is thrown:

      ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
      ORA-20000: Oracle Text error:
      DRG-10700: preference does not exist: CTXSYS.DEFAULT_LEXER
      ORA-06512: at "CTXSYS.DRUE", line 160
      ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 365

      Following grnats are given :
      GRANT EXECUTE ON CTXSYS.CTX_DDL TO <schema_name>;
      GRANT APPOWN TO <schema_name>;
      GRANT CTXAPP TO <schema_name>;


      I have verifyed the ctxsys.CTX_PREFERENCES view which is having an entry as :
      SELECT PRE_OWNER, PRE_NAME
      FROM CTXSYS.CTX_PREFERENCES
      WHERE PRE_NAME = 'DEFAULT_LEXER';

      The Result is :
      PRE_OWNER     PRE_NAME
      SYS     DEFAULT_LEXER


      Can you please assist if there is a way to update the permission on this DEFAULT_LEXER preference to set the PRE_OWNER as CTXSYS ?

      Thanks